Skip to main content.

Job Scheduling < Basics < Adapters

informatica-l

Messages for informatica-l

informatica-l

RE: Custom SQL for inserting data in Target Table: No replies...... :|
3 July 2009
Infa load is going very slow: HI, I have ampping while will load around 40 million records as inserts fro
3 July 2009
Re: Using Pushdown optimization option: Ronaldo is right. If you are not able to see the pushdown optimization then
3 July 2009
RE: Standard ETL Test Plan: Can you provide a bit more details on this. What kind of testing are you pl
3 July 2009
Standard ETL Test Plan: can any one provide me the temlate for ETL Test Plan based on the standard
3 July 2009
Re: Loading 2 source data into single target: Hi, Q)u have 2 sources. 1 for each country location. They both have same se
3 July 2009
RE: informatica 8.1.1 installation on oracle 10g: Hi.. Pls refer installation and configruation guide step by step if you are
3 July 2009
Re: informatica 8.1.1 installation on oracle 10g: Do you have any other database installed in your system other than oracle ,
3 July 2009
RE: informatica 8.1.1 installation on oracle 10g: I checked the database access (between I am oracle DBA ) so I did checked a
3 July 2009
RE: mapping parameter: Check whether parameters was correctly set from parameter file. Get session
2 July 2009
Re: informatica 8.1.1 installation on oracle 10g: While creating repository you must have given user id and password of the d
2 July 2009
Re: through put from session: I will suggest you to execute the sql in the oracle sql plus and see how mu
2 July 2009
Re: Issue in Sequence Generator: Hey are you sure that you are populating the sequence value from "NEXTVAL"
2 July 2009
Re: Mapping running for 17 hours: yes ,send me the log to thiyaga11@gmail.com On Thu, Jul 2, 2009 at 8:13 AM,
2 July 2009
Re: PowerCenter - the list of groups and their users?: If you have power center 8.x ,you have to Login to the admin console and lo
2 July 2009
RE: Custom SQL for inserting data in Target Table: thiyagarajan-rajen 'Log Source Row Data' is not what I am looking for. My
2 July 2009
RE: Issue in Sequence Generator: If the reset option isn't set, there is no reason the sequence generator sh
2 July 2009
RE: Mapping running for 17 hours: You are not being very forthcoming here... "There are not many transformati
2 July 2009
Development and Production Repositories: Hi! I'm looking information about how to install and setup a development an
2 July 2009
RE: IN function: Guys, U can do this like below where $$VALUES = BA,AB,BC ( no quotes pls)
2 July 2009
Re: Mapping running for 17 hours: use the partitoning in the session and divide the whole 28m records into re
2 July 2009
Re: Using Pushdown optimization option: Has your company the license? Ronaldo. On Thu, Jul 2, 2009 at 2:25 PM, rote
2 July 2009
Re: Loading 2 source data into single target: u can create a new parameter file with the required information from the 2
2 July 2009
Using Pushdown optimization option: Hi, I am using Informatica 8.1.1 and I can't find the pushdown optimization
2 July 2009
RE: Loading 2 source data into single target: Thanks for the reply. the second approach is whereI going for. using 2 parm
2 July 2009
PowerCenter - the list of groups and their users?: How do I access the table PowerCenter(8.6) the list of groups and their use
2 July 2009
Re: Mapping running for 17 hours: Try to use hash join in the SQL On 7/2/09, simikishore via informatica-l
2 July 2009
RE: Mapping running for 17 hours: Hi thiyagarajan-rajen , Is there an email I can send the session log or sho
2 July 2009
Re: Custom SQL for inserting data in Target Table: Hi manish, As Harish told you can implement using Target table update over
2 July 2009
RE: Source Analyzer Menu tool disabled.: hi Harish thnx for the post. i saw what you mentioned and looks like they a
2 July 2009
RE: Field Name: Hi. Create output ports in the expression and hardcode field names which yo
2 July 2009
Field Name: Hi, Is it possible to use the field names instead of the field values in an
2 July 2009
RE: Add two dates fields to date field: Hi Shastry, What samzo said is correct , But using DATE_DIFF can mention th
2 July 2009
RE: Issue in Sequence Generator: No. I havn't check the Reset Option also none of the other mappings loading
2 July 2009
RE: Problem with Scheduling: Hi.. Can you reset and set the scheduling time again and see if it works. T
2 July 2009
RE: Problem with Scheduling: Rajiv thanks for ur quick replay. All other workflows in the same server ar
2 July 2009
RE: Schedule workflow to run between intervals daily: Hi, I guess you can acheive this using informatica scheduler itself. Check
2 July 2009
RE: Problem with Scheduling: Check the timing on the server where informatica is installed ? /Rajiv
2 July 2009
RE: Convert the C*program to informatica.: Hi... Cant find the C* program... /Rajiv
2 July 2009
Problem with Scheduling: Hi gurus, we have a situation like this, one workflow is scheduled at 11:00
2 July 2009
Convert the C*program to informatica.: Hi, I have this c*program that reads the file generated by informatica and
2 July 2009
RE: Source Analyzer Menu tool disabled.: Have you tried creating a new mapping in the same? More on this, pls. go to
2 July 2009
RE: Error - [PCSF_10007] Cannot connect to repository: Hi, Vista is not supported with INFA. Simply change your base OS and then d
2 July 2009
RE: Custom SQL for inserting data in Target Table: Hi, You can write the custom SQLs using the Target Override property availa
2 July 2009
RE: informatica 8.1.1 installation on oracle 10g: while creating repository it does not ask for username and password or do y
2 July 2009
Re: informatica 8.1.1 installation on oracle 10g: Try to use the domain user name and password to create repository service a
2 July 2009
Re: Custom SQL for inserting data in Target Table: In informatica ,you can very well log the source data to a DB table.Try usi
2 July 2009
RE: Custom SQL for inserting data in Target Table: Wouldn't calling a Stored Procedure for every row slow down the performance
2 July 2009
RE: informatica 8.1.1 installation on oracle 10g: Hi , I am getting the same error The following error occurred while perfor
1 July 2009
RE: Custom SQL for inserting data in Target Table: Create stored procedure which performs custom insert as per your requirment
1 July 2009
RE: targeting to a flat file: Hi.. Donot output header or metadata to the target, instead create header r
1 July 2009
RE: Best Way of using Arthemetic operations: Try this... Declare two variables, v_VAR1 of integer/double type and v_VAR2
1 July 2009
RE: through put from session: Source is an sql which joins two Oracle tables. Target is a flat file. Sour
1 July 2009
RE: through put from session: Hi, The source is an SQL which joins two Oracle tables. Target is a flat fi
1 July 2009
RE: Custom SQL for inserting data in Target Table: Well, I wish to create a simple mapping : DB2 as source->Source Analyser->T
1 July 2009
Re: through put from session: Please tell us whether the source and target DB are one and the same or not
1 July 2009
Re: Custom SQL for inserting data in Target Table: You should be able to handle the custom part in informatica mapping itself.
1 July 2009
through put from session: Hi, I am trying to extract records from a huge DB. As the I increase the da
1 July 2009
Custom SQL for inserting data in Target Table: Hi, I want to enquire if I can write custom INSERT SQL statement for a tar
1 July 2009
Source Analyzer Menu tool disabled.: Hi, I am newbie to Informatica, although I have sound understanding and ex
1 July 2009
Re: Loading 2 source data into single target: Correct me if i am wrong, you have only one source instance which has simil
1 July 2009
Re: Loading 2 source data into single target: couple of ways you can do this - Parameterize the Source table ($$SRC_TBL)
1 July 2009
Re: Mapping running for 17 hours: If it is taking 10 mins from Oracle it should take ~ same time from SQ Tra
1 July 2009
Re: Mapping running for 17 hours: Did you try to get the count alone against the oracle table and see how muc
1 July 2009
Loading 2 source data into single target: Hi Guys, I have a situation which might be more familiar to many. I have 2
1 July 2009
Mapping running for 17 hours: Hi, I have an issue WITH THE Informatica MAPPING?.. I have a mapping which
1 July 2009
RE: Best Way of using Arthemetic operations: You are taking the substring of a number. What are you trying to do?
1 July 2009
RE: Error - [PCSF_10007] Cannot connect to repository: I ran into same issue. -- The following error occurred while performing a r
1 July 2009
Best Way of using Arthemetic operations: Hello everyone, Please suggest me the best way for performing the arthemeti
1 July 2009
RE: targeting to a flat file: This has come up before. It is a known problem, some have already opened a
1 July 2009
targeting to a flat file: Hi, While targeting to a flat file (with the field names), it looks like in
1 July 2009
Re: Outputing to excel and attach it to email: Thanks Rishi. That was very helpful. ________________________________ From
1 July 2009
Re: mapping with rowcount compare: Here is my solution.I hope your row count is less. I do it using three pipe
1 July 2009
Transaction and Aggregator: Hi, do I understand transactions well, if I think, that when transaction of
1 July 2009
RE: DAC Server failed to start: Hi, Please check the config.bat file set the following as per your machine
1 July 2009
RE: how to trigger 2 scripts using a single command task: alternatively you can call both scripts from one script... For instance scr
1 July 2009
RE: how to trigger 2 scripts using a single command task: yes...you can do it...add multiple commands in the command task. /Rajiv
1 July 2009
RE: AdminConsole Window Problem: I am using windows only,I am trying the same way as you told but still faci
1 July 2009
how to trigger 2 scripts using a single command task: Hi Please let me know whether we can trigger 2 scripts using a single comma
1 July 2009
RE: AdminConsole Window Problem: Hi.. You can also find/connect to AdminConsole from the Startup->Programs->
1 July 2009
RE: AdminConsole Window Problem: Hi.. You should specify domain hostname ie., m/c on which informatica is in
1 July 2009
RE: Need SYSDATE - 1 in expression transformation for effective tracking: Use this ADD_TO_DATE(sysdate,'ddd',-1) Regards Balakrishna
1 July 2009
AdminConsole Window Problem: Hello Friends, I am not able to open the admin console window, when i am tr
1 July 2009
Schedule workflow to run between intervals daily: Hi, I would like to schedule a workflow in Informatica 8.6 to run dai
1 July 2009
RE: Issue with worklet variable: Hi.. Pls try this method... |->cmd Start->Timer1->Session1 |->T
1 July 2009
RE: Client connection on repository refused (although all services are up): Hi Rajiv, thanks for your reply. I tried connecting with the Administrator-
1 July 2009
RE: Client connection on repository refused (although all services are up): Hi.. When you installed informatica on the windows machine you were prompte
1 July 2009
RE: Outputing to excel and attach it to email: Hi, You can populate the data in an excel file (*.csv) and then use the On
1 July 2009
RE: Client connection on repository refused (although all services are up): Hi Harish, thank you very much for the answer, but I'm already using the us
1 July 2009
RE: Session Properties missing?: Hi BNR, Please share your mapping logic with us. Regards, Vikas. __________
1 July 2009
RE: Client connection on repository refused (although all services are up): Hi, You need to use the same username and password, which you have used dur
1 July 2009
RE: Issue with worklet variable: Hi, You cannot use the variable's declared inside the worklet in your workf
1 July 2009
RE: mapping with rowcount compare: You can make a stored procedure for comparing the row counts and it should
1 July 2009
RE: Session Properties missing?: You can also check for the property where on running the session the target
1 July 2009
Re: loading data into 3 targets with cyclic process: Hi Sunil, Just i mentioned 30 records as example we want to load more than
1 July 2009
execution terminated unexpectedly: Hi experts, we are facing the error of 'execution terminated unexpectedly'
1 July 2009
RE: Session Properties missing?: Hi.. Apply correct filter on the update pipeline. May be your condition is
30 June 2009
RE: mapping with rowcount compare: Just an addition I did this til now Flow 1: A.txt_>SQ->EXP->A oracle TARGET
30 June 2009
mapping with rowcount compare: I have a urgent requirement and my logic is not working: I have a flat file
30 June 2009
Session Properties missing?: I have created a type 1 dim, looks like everything is working fine. I am te
30 June 2009
RE: Outputing to excel and attach it to email: You can write out to excel if you have an adapter I believe. Otherwise,
30 June 2009
Re: Outputing to excel and attach it to email: Definitely you should be able to do that. Just refer to Informatica help fo
30 June 2009
Outputing to excel and attach it to email: Is it possible to output data into excel spreadsheet and then attach the ou
30 June 2009
Percentile function in Excel and Informatica: Hi The following is an example given in the Informatica Help files
30 June 2009
Re: loading data into 3 targets with cyclic process: Hello, What if are dealing with first 30 records, with the same 3 targets e
30 June 2009
RE:Can we import few mapping object of 8.1 to 8.6? Where 8.6 is a new repository.: Hi, I would recommend looking at myinformatica.com where informatica have
30 June 2009
Client connection on repository refused (although all services are up): Hey guys, i have a particular problem with my Informatica PowerCenter Insta
30 June 2009
RE: Need SYSDATE - 1 in expression transformation for effective tracking: I did use ADD_TO_DATE(SYSDATE,'DD',-1) but gave transformation error (the
30 June 2009
RE: Can we import few mapping object of 8.1 to 8.6? Where 8.6 is a new repository.: You can go from 7.x and 8.x to 8.6, however Informatica does not recommend
30 June 2009
Issue with worklet variable: Hi i have declared a variable $$a in worklet variable and from parameter fi
30 June 2009
Re: loading data into 3 targets with cyclic process: Hello All, Please find below the logic. Source table contains only one colu
30 June 2009
RE: Lookup Cache creation takes long time.: Hey that was really very useful although i am not facing the issue right no
30 June 2009
RE: BLOB Data type Transfer with Informatica: Hi.. Informatica 8.x supports oracle BLOB data type. When you use source qu
30 June 2009
BLOB Data type Transfer with Informatica: How to transfer BLOB datatype from one oracle table to another oracle table
30 June 2009
RE: Can we import few mapping object of 8.1 to 8.6? Where 8.6 is a new repository.: Hi Harish, Thanks for ur reply .Actually We are starting a
30 June 2009
RE: Can we import few mapping object of 8.1 to 8.6? Where 8.6 is a new repository.: Can we do the same..... The mapping objects which r created in Infa 7.x ver
30 June 2009
RE: Lookup Cache creation takes long time.: Thanks a lot Rajiv it was really helpful
30 June 2009
RE: Can we import few mapping object of 8.1 to 8.6? Where 8.6 is a new repository.: Yes, you can do so. Go to repository manager --> export the folder that you
30 June 2009
RE: Lookup Cache creation takes long time.: Hi, Pls find details on MD5 function usage with and SCD1 type mapping examp
30 June 2009
Re: Need SYSDATE - 1 in expression transformation for effective tracking: U can use ADD_TO_DATE(SYSDATE,'DD',-1) On Mon, Jun 29, 2009 at 2:59 PM, HSi
29 June 2009
Re: Lookup using default sql instead of lookup condition: Can u check in session that lookup override had been reflected or not?? On
29 June 2009
Need SYSDATE - 1 in expression transformation for effective tracking: Hi, How can I do SYSDATE - 1 in expression transformation in mapping? Thi
29 June 2009
RE: Lookup using default sql instead of lookup condition: The lookup condition is how the mapping locates data in the lookup cache.
29 June 2009
RE: Lookup Cache creation takes long time.: 'Another option is to use MD5 Checksums. The preferred solution is to store
29 June 2009
RE: Lookup Cache creation takes long time.: Hi Brain /Rajiv can you please explain more on this MD5 Checksum in lookup?
29 June 2009
RE: Variable Port Issue: Hi Rajiv and venky....thanks a ton for investing your valuable time and eff
29 June 2009
Re: Lookup using default sql instead of lookup condition: Hi, Just needed a little clarification.The query , which you are referring
29 June 2009
RE: PMCMD StartTask working from Command Prompt, but not Informatica task: I figured it out. When I run the .cmd line from within the same workflow a
29 June 2009
Lookup using default sql instead of lookup condition: Hi, I created a lookup initially with lookup condition and it was wor
29 June 2009
Invoking Informatica workflow through Web client(.NET): Champs, I'm writing a Client Application in C# for Batch Web Services which
29 June 2009
RE: Lookup transformation SQL ODBC picks up Source Qualifier SQL ODBC and vica versa: This is the error I am getting in workflow... Help!!!! From: informati
29 June 2009
Can we import few mapping object of 8.1 to 8.6? Where 8.6 is a new repository.: We have installed informatica 8.6 and we have an existing repository runnin
29 June 2009
Re: Error while importing the XSD in Informatica 8.6.1: I hope ur using / having source as XML (flat file). XSD file is used import
29 June 2009
RE: Variable Port Issue: Sort col1 in ascending order using sorter transformation . put a lookup o
29 June 2009
Re: loading data into 3 targets with cyclic process: ok thanks venkat finally i got answer. Thanks Nandu On Mon, Jun 29, 2009 at
29 June 2009
RE: loading data into 3 targets with cyclic process: Yeah ... Initially i've used AND , later i changed it to OR . I have no r
29 June 2009
Re: loading data into 3 targets with cyclic process: Thanks venkat for ur reply but i think we want to use AND instead of OR the
29 June 2009
RE: How to implement a decision at the starting of the workflow: Hi... I am suggesting to define workflow variable and initialize it in para
29 June 2009
RE: loading data into 3 targets with cyclic process: Process the first 15 records using the logic in my previous post . for the
29 June 2009
Re: loading data into 3 targets with cyclic process: it is very helpful if you u get a chance to provide the detail logic that t
29 June 2009
RE: How to implement a decision at the starting of the workflow: hi.. this brings back us to the very first question.. i am not able to upda
29 June 2009
RE: loading data into 3 targets with cyclic process: Hi... All you have to do is to scan through the sequence and keep on counti
29 June 2009
RE: How to implement a decision at the starting of the workflow: If that is the case then use parameter file. Declare and initialize workflo
29 June 2009
Re: loading data into 3 targets with cyclic process: please consider records are more than 1000 in source. On Mon, Jun 29, 2009
29 June 2009
Re: loading data into 3 targets with cyclic process: i know this logic if records are less. if records are in millons then we ca
29 June 2009
RE: loading data into 3 targets with cyclic process: Since the source records are in sequence , Put a sequence generator and imp
29 June 2009
RE:Informatica Server Repository Start Error: hi, i am trying to install informatica 8.1.1 in my windows xp system. can
29 June 2009
Re: loading data into 3 targets with cyclic process: I had only one source column like seqnum i want this seq nums to different
29 June 2009
RE: Copying repository users and groups: There is an easier way of copying the users and groups. use infacmd exportu
29 June 2009
RE: How to implement a decision at the starting of the workflow: Hi Rajiv, I tried the option provided but in the pre or post variable assig
29 June 2009
Re: loading data into 3 targets with cyclic process: I had only one source column like seqnum i want this seq nums to different
29 June 2009
RE: Workflow already exists !: Thanks Ronaldo , Hemanta and Anjananjan .... you all were right ! When I fo
29 June 2009
RE: loading data into 3 targets with cyclic process: Hi.. Add Router transformation and create three groups and set appropriate
29 June 2009
RE: Informatica Server Repository Start Error: Please give more informatiion regarding your question. How did you import t
29 June 2009
RE: loading data into 3 targets with cyclic process: * Column1 | Column2 | Column3 Yes | No | No * Use a R
29 June 2009
Re: loading data into 3 targets with cyclic process: source records are in sequence only On Mon, Jun 29, 2009 at 11:23 AM, babur
29 June 2009
loading data into 3 targets with cyclic process: I had 100 records in my source i want to load first 5 records into 1 target
29 June 2009
RE: Variable Port Issue: Addition to my previous post...flow looks like this in the mapping designer
29 June 2009
RE: Variable Port Issue: Hi.. Try following steps to do it in informatica mapping! 1. Create two Sou
29 June 2009
RE: Variable Port Issue: Hi... I think logic is not working correctly you can ignore it but instead
29 June 2009
Importing VSAM files into PowerCenter: Hi all, Is there anyway to import a VSAM file into Informatica Power Cente
28 June 2009
Re: Adding previous column value to the current one: plz the below explanation. 1st record: i_col -> current value v_col = i_col
28 June 2009
Re: Identify Session Task Overrides from OPB?: I am not sure abt querying OPB tables r REP views may give sol fr this.. ap
28 June 2009
Adding previous column value to the current one: Can you please walk me through the detailed expressions maintaining proper
28 June 2009
Unable to read the unicode characters...: I need to read the unicode & compare the unicode data each and every palce
28 June 2009
RE: Identify Session Task Overrides from OPB?: Yes, I was definitely looking for an OPB or REP table SQL query to quickly
28 June 2009
RE:Workflow already exists !: Hi Rahul, I think the repository is versioned. Remove the workflow from his
28 June 2009
Re: Workflow already exists !: Hi, I agree with reply from Ronaldo. If the INFA Team based devlopment is o
28 June 2009
Re: Workflow already exists !: Dude do one thing -----go to the Repositry DataBase and you will find a ta
28 June 2009
RE: Workflow already exists !: Thanks to all for your reply .But the issue is a bit bigger , it seems I di
28 June 2009
Re: Workflow already exists !: i guess u might not have saved after u deleted the wkfl and tried to create
28 June 2009
RE: PMCMD StartTask working from Command Prompt, but not Informatica task: Hi.. I suspect on file extension .cmd on windows. You can try renaming it t
28 June 2009
RE: How to implement a decision at the starting of the workflow: Hi.. Mapping variable value will be available and can be assigned session l
28 June 2009
Re: Workflow already exists !: You need to save and then find all checked out objects then make a check in
27 June 2009
RE: Workflow already exists !: When deleting workflow, save and then recreate with same name. It won't as
27 June 2009
Workflow already exists !: I am working on Informatica version 8.1 .1 . Sometimes earlier , I deleted
27 June 2009
RE: Lookup transformation SQL ODBC picks up Source Qualifier SQL ODBC and vica versa: I was able to set the ODBC connection in Source Qualifier and Lookup. Howe
27 June 2009
RE: Lookup Cache creation takes long time.: Hi Brain/Rajiv, Can you please explain more on using MD5 Checksum in look
27 June 2009
RE: How to implement a decision at the starting of the workflow: Hi Rajiv, Thanks a lot for your reply, i will definetly try this option out
27 June 2009
Re: Stored proc with no output port: Hi, I have nt worked on stored proc transfforamtion.I have a similar requ
27 June 2009
Re: Lookup transformation SQL ODBC picks up Source Qualifier SQL ODBC and vica versa: Hi, Can you try passing the required ODBC connection string to source/looku
27 June 2009
RE: Unable to create repository content: is it resolved. -----Original Message----- You can view Activity Log. It se
27 June 2009
RE: Problem in installation of Informatica Powercenter 8.1: Hi Shikha, When time of node configuration i ddn't see the UTF-8 encoding o
27 June 2009
Chaging the node character set from ms windowa latin 1 to UTF 8: when time of installing the informatica i have set the code page as ms wind
27 June 2009
Re: Flat File to XML generation using XML Generator Transformation: use normalizer to pivot the column values to rows and then generate xml fil
26 June 2009
PMCMD StartTask working from Command Prompt, but not Informatica task: Goal: restart the workflow from a specific session by calling that session
26 June 2009
Lookup transformation SQL ODBC picks up Source Qualifier SQL ODBC and vica versa: Hi, When I go to validate the Source Qualifier SQL, I choose the ODBC and
26 June 2009
Re: Evaluate a time taken by lookup: What is your underlying database? Do you have an index on the condition por
26 June 2009
Re: xml source and target definition: I have an xml file I have to use the xml file and load the data. On Sat,
26 June 2009
Re: xml source and target definition: You need an XSD (XML Schema Definition) to extract the data from XML's and
26 June 2009
xml source and target definition: How to create xml source and target definition using xml file which gets da
26 June 2009
RE: Stored proc with no output port: Did you try making it as unconnected stored procedure transformation and ca
26 June 2009
Start workflow using Java transformation: H, Can I start a workflow using a java transformation command ? I don't wan
26 June 2009
RE: Stored proc with no output port: That wont do for me. I have to pass parms to it from the mapping. The store
26 June 2009
Calling SAP RFC function: Hi, When I try calling a SAP RFC function with import parameter and output
26 June 2009
Oracle table does not exists error: Could you please help me to solve this annoying problem? I am using Inform
26 June 2009
RE: Stored proc with no output port: Hi.. Call the procedure in Pre or Post sql of target or can be called in po
26 June 2009
RE: Informatcia 7.1.5 : Processing a file with Header Detail and Trailer: Hi.. Does source file has header and trailer, if not then read file and cre
26 June 2009
RE: Informatica for moving files between document servers: Hi.. FTP would be the best option, but any OS scripting should be handy for
26 June 2009
RE: Issue in Sequence Generator: Hi... You can generate sequence within the mapping or use mapping variable.
26 June 2009
Evaluate a time taken by lookup: Hi, I am using a lookup in uncached mode as its a real time integration w
26 June 2009
RE: How to implement a decision at the starting of the workflow: Hi.. If you are using 8.x version, you can save value in mapping variable a
26 June 2009
RE: Variable Port Issue: Hi.. After you get extra record 0 and 0 for col1 and col2, pass col1 and co
26 June 2009
RE: Cannot DD_UPDATE (update strategy) on unique key only when primary key is present: I was able to do update override in target and it worked. I was not able t
26 June 2009
Affected rows greater than applied rows: Hi, I've a mapping as follows : Flat File -> SQ Qual -> EXP-> LKP->
26 June 2009
How to implement a decision at the starting of the workflow: Let me explain the requirement... In one workflow their are 3 pipelines fro
26 June 2009
RE: Cannot DD_UPDATE (update strategy) on unique key only when primary key is present: Right now I am testing for a specific party_id, where at first I inserted
26 June 2009
RE: Issue in Sequence Generator: Avoid using Sequence Generators in Informatica unless they are being used w
26 June 2009
RE: Informatcia 7.1.5 : Processing a file with Header Detail and Trailer: Yes, but it usually isn't pretty. Because record layouts are Header/Detai
26 June 2009
RE: Cannot DD_UPDATE (update strategy) on unique key only when primary key is present: Try either a Update Override in your target or just change your target defi
26 June 2009
Stored proc with no output port: I have a store proc that does not return any value. It just updates a table
26 June 2009
RE: Cannot DD_UPDATE (update strategy) on unique key only when primary key is present: More on this, I have a doubt on your logic as well. If LKP_Party_ID is null
26 June 2009
RE: Informatcia 7.1.5 : Processing a file with Header Detail and Trailer: Hi, Your requirement seems to be a do-able job. If you would have explained
26 June 2009
RE: Variable Port Issue: Hi Rajiv...First of all thanks a lot for your quick response and suggestion
26 June 2009
Flat File to XML generation using XML Generator Transformation: Hi, I?ve a requirement to generate XML from flat file through Informatic
26 June 2009
RE: Error while importing the XSD in Informatica 8.6.1: I guys! I have the same problem this week. I had used the XML liquid to and
26 June 2009
RE: Issue in Sequence Generator: Is the table getting loaded by other mappings too ?
26 June 2009
Informatcia 7.1.5 : Processing a file with Header Detail and Trailer: Is it possible in Informatica 7.1.5 in a single map, to read / write data f
26 June 2009
RE: Informatica for moving files between document servers: humm.. Personally, I do not think that Informatica should be used as a file
26 June 2009
Informatica for moving files between document servers: Hi, Just wondering can anyone through some light on the capability of
26 June 2009
RE: The same source object for multiple excel files with the same format, but vastly different names: Try working with the concept of File List. Regards, ~Harish
26 June 2009
RE: Issue in Sequence Generator: Hi, RESET option in SEQG Transformation would cause this problem. Ensure th
26 June 2009
Re: Informatica 8.5 server is shutting down automatically: Let me know the reason for improting XSD file, Basically i want to understa
26 June 2009
RE: Informatica 8.5 server is shutting down automatically: I changed the root dir to a different folder and the service is starting. I
26 June 2009
Re: Issue in Sequence Generator: Have you checked Reset Restart options in Seq.Gnr On Fri, Jun 26, 2009 at 1
26 June 2009
Re: Error while importing the XSD in Informatica 8.6.1: If it is validated in Liquid XML, then thats a perfect XSD? Problem could b
26 June 2009
RE:Existing rows target table migration problem: Thanks Rajiv R Chitlur and all others who help me. I got solution. Regards
26 June 2009
Issue in Sequence Generator: Hi, I have created the mappings with sequence generator transformation and
26 June 2009
Cannot DD_UPDATE (update strategy) on unique key only when primary key is present: Hi, I am trying to use update strategy in mapping based on target lookup
26 June 2009
The same source object for multiple excel files with the same format, but vastly different names: The question is in the title. Basically I have excel files with the same fi
26 June 2009
RE: MySQL with Informatica??: Hi I am able to connect it through designer after doing the necessary chang
26 June 2009
RE: Target table does not allow INSERT: For me helped: Informatica version 8.6 - Add "update strategy" "box" to th
26 June 2009
RE: Finding all mappings that use a table as source, target and lookups: Hi, Repository Queries is one the feature/Menu option introduced in version
26 June 2009
RE: Multiple mv post session command: i.e. mv c:\file1 c:\myfolder\file1 mv c:\file2 c:\myfolder\file2 mv c:\file
26 June 2009
RE: Integration Service is alive: Hi, In the Administration Console, if your Integration Services is showing
26 June 2009
RE: mysql driver error: Hi I am getting a similar problem when i am trying to insert data into mysq
26 June 2009
Re: Error while importing the XSD in Informatica 8.6.1: Hi, Thanks for your reply. But When I validate the schema with t
26 June 2009
Re: Error while importing the XSD in Informatica 8.6.1: Hi, Thanks for your reply. --- On Thu, 6/25/09, mohanyerr
26 June 2009
RE: Integration Service is alive: Hi. Login to Adminstrator Console and verify or try pinging. /Rajiv
26 June 2009
RE: Add two dates fields to date field: If I remember correctly the Informatica DAT DIFF function should be able to
25 June 2009
RE: Add two dates fields to date field: u can do this in exp_transformation by using the follwing command as output
25 June 2009
RE: Add two dates fields to date field: u can do that in expression transformation as of my idea. using the followi
25 June 2009
Re: Lookup Cache creation takes long time.: If you are using Oracle, then stage all the data into a stage table which h
25 June 2009
RE: Add two dates fields to date field: yes.... you are correct
25 June 2009
Re: Add two dates fields to date field: As per to my understanding, you trying to find number of days between two d
25 June 2009
Add two dates fields to date field: Hi, Here i have a scenario to add two input date fields say like A_DT (dat
25 June 2009
Re: Finding all mappings that use a table as source, target and lookups: Brian, Would you happen to have a sample query (what views/tables should I
25 June 2009
RE: Finding all mappings that use a table as source, target and lookups: 1. You can use queries as stated already 2. You can use repository views 3.
25 June 2009
RE: Integration Service is alive: Poke it with a stick?
25 June 2009
Purchase Order BAAN Tables and fields descriptions how to identify?: I have initial requirement like mapping of BAAN PO table fields with DW PO
25 June 2009
RE: E-mailing in Informatica Workflow: Common people, at least hit F1 and do a search in Help -- which is pretty d
25 June 2009
RE: Existing rows target table migration problem: Hi.. There should be some key fields for lookup. Just use Source as lookup
25 June 2009
RE: E-mailing in Informatica Workflow: Yes can attach file, look at the email variables %a. Refer help for syntax
25 June 2009
RE: Multiple mv post session command: Add multiple entries in the command task /Rajiv
25 June 2009
RE: Variable Port Issue: Hi.. Try using cume function to compute running sum for col2 and keep on su
25 June 2009
E-mailing in Informatica Workflow: I have a Workflow that selects from Sybase database, creted a flat file and
25 June 2009
Re: Error while importing the XSD in Informatica 8.6.1: Its an XSD validation error Its ckearly saying that error is at line 29, ch
25 June 2009
RE: How to get the worklet timing from the OPB table?: use opb_wflow_run and opb_task_inst join on workflow id
25 June 2009
How to get the worklet timing from the OPB table?: I have about 15 worklets in my workflow.At the end of the load i want to ge
25 June 2009
Multiple mv post session command: Hi All, I need to use multiple mv command through post session success comm
25 June 2009
RE: Existing rows target table migration problem: Then my understanding is correct. This is something like incremental load.
25 June 2009
Integration Service is alive: how to find Integration Service is alive?
25 June 2009
RE:File polling in Informatica 8.6: Hi Rajiv, I'm not able to register or login to my.informa
25 June 2009
RE: File polling in Informatica 8.6: Hi. You should login to my.informatica.com. Once you login you will find "B
25 June 2009
RE: Variable Port Issue: Hi.. Try using cume function to compute running sum for col2 and keep on su
25 June 2009
RE:File polling in Informatica 8.6: Rajiv, I could not locate the article. Can you provide the URL.
25 June 2009
RE:Existing rows target table migration problem: Thanks Bala I got it some useful info from your answer. But I want to clear
25 June 2009
Error while importing the XSD in Informatica 8.6.1: Hi All, I face an issue while importing CatalogueItemNotification_Rev
25 June 2009
RE: Existing rows target table migration problem: Hi, You mean there are some rows in target which are not there in source an
25 June 2009
Existing rows target table migration problem: I have some rows in target table. Now I want to migrate only that rows that
25 June 2009
RE: Informatica 8.5 server is shutting down automatically: Yes, my TNS is running, i am able to connect to the DB.
25 June 2009
Re: Variable Port Issue: create a variable port v_col_2 which should hold the value of col_2 create
25 June 2009
Re: Finding all mappings that use a table as source, target and lookups: You can try building queries in the repository manager(tools->options->quer
25 June 2009
RE: Creating control file in Informatica: You can create two mapping variables and update them with SESSIONSTARTTIME
24 June 2009
RE:informatica loading MS SQL table order: Thanks Brian. I can put sorter in my mapping and it will work perfectly. Bu
24 June 2009
Finding all mappings that use a table as source, target and lookups: Hi, What is the easiest way to find out all the mappings that use a particu
24 June 2009
Creating control file in Informatica: Hello, I have a workflow that has source as stored proc and target is a fl
24 June 2009
Variable Port Issue: I encountered the following problem: Source Table: Col_1 Col_2 1 4
24 June 2009
RE: How to change the target of one mapping as source for another mapping: If you are creating the source file definitions you can't drag the target o
24 June 2009
Re: Target invalid after import XML with XSD: *XML Guide is available in Informatica Documentation If you get the same er
24 June 2009
RE: Query Should return exactly 2 fields to match filed(s) projected from the Source Qualifier: Anand You cannot create a query for non database column in SQ. Use them in
24 June 2009
RE: Update Overirde: TE_7003 Error: This kind of error comes when informatica is not able to find the column in
24 June 2009
RE: Identify Session Task Overrides from OPB?: @Harish I think Jamal wants to find the overrides by quering the OPB table
24 June 2009
RE: Difference between lookups: There is no difference between oracle and db2 lookups. The only difference
24 June 2009
Difference between lookups: what is the difference between oracle lkp file and db2 lkp file .
24 June 2009
RE: Identify Session Task Overrides from OPB?: Hi, You can go to the session properties. Under Session Properties --> Go t
24 June 2009
RE: Update Overirde: TE_7003 Error: Hi, Ensure the the target col do have the same datatype, lenght and percisi
24 June 2009
RE: Issue Installing Informatica 8.6 in Unix: Did you try the installation on any other machine with the same setup file?
24 June 2009
RE: Need to change the sequence in a xml source qualifier: Hi, Are you sure it is properly checked out? You can also try the same by m
24 June 2009
RE: informatica loading MS SQL table order: Try putting a sorter in your mapping? Why does the order the data is stor
24 June 2009
RE: Target invalid after import XML with XSD: Thanks, I have the same errors with Entity Relationship. I have imported th
24 June 2009
RE: How to remove sequence of same symbols: probably you may have to switch to substring operations as explained in ear
24 June 2009
RE: How to remove sequence of same symbols: ok. Is there any other way we can get the desired result in informatica. Si
24 June 2009
RE: File polling in Informatica 8.6: Hi, Instead of scheduling the workflow, you can schedule the shell script i
24 June 2009
RE: How to remove sequence of same symbols: yes, it is a function, it works similar to regular expression parsers. May
24 June 2009
RE: How to remove sequence of same symbols: Hi all, Thanks for your responces. Hi Rajiv, Currently i am using Infa 8.1.
24 June 2009
RE: How to remove sequence of same symbols: @Rajiv Thanks a ton . Venkat
24 June 2009
RE: File polling in Informatica 8.6: Hi.. I have written an article "Completing a Workflow When a User-Defined
24 June 2009
RE: How to remove sequence of same symbols: Hi.. Try the following. No need to worry about occurances. If you are using
24 June 2009
informatica loading MS SQL table order: Hi, I am downloading mainframe file with binary option to informatica serve
24 June 2009
RE: Query Should return exactly 2 fields to match filed(s) projected from the Source Qualifier: If that is the case create dummy port in SQ and use proper aliasing in the
24 June 2009
RE: How can I generate a SYS_GUID() in Informatica exp.: Hi. Create Source definition with one port of raw datatype. When you drag s
24 June 2009
RE: How can I generate a SYS_GUID() in Informatica exp.: Hi... Change data type to binary in source qualifier for the sequence port
23 June 2009
Re: Target invalid after import XML with XSD: Try to Import the XSD with Entity relationship once As per your explanation
23 June 2009
Re: How to remove sequence of same symbols: What about using a Java Expression? Alberico Lima. 2009/6/23 Brian via info
23 June 2009
RE: Target invalid after import XML with XSD: Hello, I have choosed Hierarchy with Normalized XML View. The XSD has many
23 June 2009
Re: Target invalid after import XML with XSD: What is the option you choosed while importing an XSD Entity relationship o
23 June 2009
RE: How to remove sequence of same symbols: A function or stored procedure would not be really all that efficient, unle
23 June 2009
Target invalid after import XML with XSD: Hi guys, I have imported a target from a xsd. But after that my target is i
23 June 2009
Re: How to remove sequence of same symbols: Better would be to write the function or stored proc, pass the input field
23 June 2009
RE: Informatica 8.5 server is shutting down automatically: I don't think node is the cause for this. check your TNS listener is up and
23 June 2009
RE: Issue with Informatica 8.6 Installation on Windows vista: Harish is correct. But you can try if you have Vista business not on Home.
23 June 2009
RE: How can I generate a SYS_GUID() in Informatica exp.: Rajiv, This is good idea. but still have issue. Since target table field da
23 June 2009
RE: Query Should return exactly 2 fields to match filed(s) projected from the Source Qualifier: thanks for the reply..where should i write the query.. Currently I have wri
23 June 2009
RE: How to remove sequence of same symbols: If you can define some boundaries, like can expect to only have five or les
23 June 2009
RE: Looking at new scheduling solutions (BMC, Title or UC4): The Informatica Scheduler is a big steaming pile of dog poo. The sole reaso
23 June 2009
RE: File polling in Informatica 8.6: Your best bet is to start the workflow at 5am and have it call your shell s
23 June 2009
RE: How to remove sequence of same symbols: You ca get the first part of the string before - and second part after - an
23 June 2009
RE: File polling in Informatica 8.6: Yes, you can specify the time between 5 to 7 to run the scheduler for file
23 June 2009
File polling in Informatica 8.6: 23 June 2009
RE: Issue with Informatica 8.6 Installation on Windows vista: Hi All, for the Exit Code : S, the solution is : Grant all the Privileges a
23 June 2009
RE: Teradata to Informatica: You can try with lookup transformation. -Bala
23 June 2009
RE: How to remove sequence of same symbols: I forgot to menton this condition. If a field has value as AB-BCD-----D-F.
23 June 2009
How to remove sequence of same symbols: Hi Gurus, I have a source file like this ABC-----EF A------EF A-GH D----H I
23 June 2009
Informatica 8.5 server is shutting down automatically: I am running an informatica 8.5 server for past 9 months. Recently Itried t
23 June 2009
RE: MySQL with Informatica??: Hi I am using informatica 7.1 and i can't see any option to add the custom
23 June 2009
Re: Power exchange 8,5: yes --u can definitely add select and where clause while doing row test its
23 June 2009
RE: MySQL with Informatica??: Update powrmart.ini file In informatica/Client/bin by adding MySQL=EXTODBC
23 June 2009
RE: Looking at new scheduling solutions (BMC, Title or UC4): Quite an impressive list of schedulars available in the market, as shared b
23 June 2009
RE: Teradata to Informatica: Can't you create an dummy temp table containing the results for all the 4 t
23 June 2009
RE: Looking at new scheduling solutions (BMC, Title or UC4): Hi... Its better to have third party scheduler as it gives greater control
23 June 2009
RE: Informatica Server Repository Start Error: Hi, Did you try creating the fresh repository without any content and then
23 June 2009
RE: Informatica LM error: Hi, Do you have adequate memory allocations for your DTM Buffer and Pool? D
23 June 2009
RE: How can I generate a SYS_GUID() in Informatica exp.: Hi.. Create dummy Source Qualifier with one port of width string (32) and i
23 June 2009
How can I generate a SYS_GUID() in Informatica exp.: Hi, I have target table with one if the field data type is RAW(16). this is
22 June 2009
RE: LTRIM, RTRIM: I am not sure whether u found the solution or not but i happened to see you
22 June 2009
RE: informatica problem about icetss.hp:261: I also need this EBF92770. Where can i get, is there any help, plz let me k
22 June 2009
Informatica LM error: Hi While running the jobs one of my session being terminated unexpectedly
22 June 2009
Teradata to Informatica: How to convert 4 tables inner joins with differenet conditions in informati
22 June 2009
RE: rank transformation: Hi Srikiran, If you are implementing the above logic using sequence generat
22 June 2009
RE: how to pick parts of value from oracle column: At this moment I don't have more values, but using INSTR and SUBSTR will be
22 June 2009
RE: rank transformation: Hi Srikiran, Answering to your question: Source data: sno sname smarks 1 ar
22 June 2009
Converting SQL Server TEXT-column to AS-400 DB2 CLOB-column, with PowerCenter 8.1.1 and iSeries Access ODBC: I'm convert a SQL Server table, containing TEXT-column to a AS-400 DB2-UDB
22 June 2009
Informatica Server Repository Start Error: Hi, We are importing the Production Informatica repository to the test env
22 June 2009
RE: How to collect duplicate datas from source ?: You can do the same with the help of expression transformation also. Create
22 June 2009
RE: MySQL with Informatica??: Hi Thanks for your reply. I am not very sure where to add the OptimizeODBC
22 June 2009
Issue Installing Informatica 8.6 in Unix: Hi, I tried to install informatica 8.6 in unix in console mode. While runni
22 June 2009
RE: Query Should return exactly 2 fields to match filed(s) projected from the Source Qualifier: I think you are mapping only two ports forwards. Use non database field's i
22 June 2009
RE: MySQL with Informatica??: Configuring the Integration Service ( For MySQL Read and Write to work Prop
22 June 2009
RE: MySQL with Informatica??: Hi, I am trying to establish a MYsql db connection in informatica. I have s
22 June 2009
Query Should return exactly 2 fields to match filed(s) projected from the Source Qualifier: Hi, I am a beginning in Informatica. I need to create a flat file out of a
21 June 2009
Object Count in Output card of Mercator Map: Hi Gurus, I am developing mercator map, to map database fields and records
20 June 2009
Update Overirde: TE_7003 Error: Hi Im using Update Overide code in my target definition. There is no prima
20 June 2009
Identify Session Task Overrides from OPB?: Can anyone tell me how to identify all session/task overrides at the worfkf
20 June 2009
RE: how to pick parts of value from oracle column: You can use SUBSTR and INSTR functions, but fthe string pattern and format
20 June 2009
RE: How to collect duplicate datas from source ?: count() in AGG will work, but it depends on your requirement. -hari
19 June 2009
Need to change the sequence in a xml source qualifier: How do you change the sequence in a xml source qualifier? I've checked out
19 June 2009
How to collect duplicate datas from source ?: I have to collect duplicate datas from source and load it to a Error target
19 June 2009
Looking at new scheduling solutions (BMC, Title or UC4): Which product would be the best choice since we are requiring access to Inf
19 June 2009
RE: Not able to set new values to Mapping Variables: Thanks Brian, using parameter file to override the values of variables help
19 June 2009
RE: What happens first? Lookup file creation or pre-session command task execution.: Pre-Session command fires first. You can determine this by the log files.
19 June 2009
RE: PostgreSQL database and Informatica 8.1.1: If your system is unix-based, you can use the PostgreSQL or UNIXODBC drive
19 June 2009
RE: Not able to set new values to Mapping Variables: What do you have as the aggregation setting? If your new value doesn't meet
19 June 2009
RE: Unexpected Condition Detected Error in Informatica 8.6.1: I would suggest contacting Informatica Support.
19 June 2009
how to pick parts of value from oracle column: Hi all, I have a column in Oracle table that can have html code and I need
19 June 2009
RE: Unexpected Condition Detected Error in Informatica 8.6.1: Hi, I am getting the same error in the Powercenter Designer.But the Error m
19 June 2009
Not able to set new values to Mapping Variables: There is a mapping which reads a xml file and set value to a mapping variab
19 June 2009
PostgreSQL database and Informatica 8.1.1: Hi Team, I want to establis connectivity between PostgreSQL database an
19 June 2009
What happens first? Lookup file creation or pre-session command task execution.: Hi All, I have a question. Lets say i have a mapping which uses lookup on c
19 June 2009
Power exchange 8,5: Hello Folks, I hav been using PowerExchange(PWX) 8.5 from past few months.
19 June 2009
RE: How can I remove single quote symbol in a string: Hi Sandeep, Create a expression transformation: i_string (input port) o_str
19 June 2009
Unexpected Condition Detected Error in Informatica 8.6.1: Hi, I got the following error while executing the workflow. It states that
19 June 2009
RE: How to create this mapping?: Hi Tinks, When you are using the source and target as same and updating bas
19 June 2009
RE: How to create this mapping?: Hi Tinks, modify the first port of the target column as primary key, this i
19 June 2009
Re: Rank Transformation: we can ....surely ....but both need to have input from same source and you
19 June 2009
Re: How to create this mapping?: Hi Tinks, The way you are working is correct but there might be a some lock
19 June 2009
RE: How to create this mapping?: I think it was confusing I have a oracle source [table x] with two fields m
19 June 2009
RE: Implement Update timestamp of old recs and insert new recs: probably you its a combination of scd1 and scd2. I suggest you to understan
19 June 2009
RE: flat file with two headers: Thanks Rajiv I will let you know
19 June 2009
RE: flat file with two headers: Hi.. Try this.. v_out = IIF(v_time = time OR time <> 'evening','Y','N') /Ra
19 June 2009
RE: Crystal report 2008 server: Seems that you have posted the problem is wrong area. You would further lik
19 June 2009
RE: How to create this mapping?: u mean to say two fields without PK and mapped to the same target and u wan
19 June 2009
RE: flat file with two headers: Rajiv , Thanks for the reply. That happens to be the best solution but I wa
19 June 2009
How to create this mapping?: I have a oracle source with two fields my_first_date =06/01/2009 my_second_
18 June 2009
RE: SQ criteria using two table from different database instances: The link will work, but when I implement timestamp tables like that, I firs
18 June 2009
Re: How can I remove single quote symbol in a string: u can use replacestr() by defining the single quote in ascii value.... On T
18 June 2009
RE: How can I remove single quote symbol in a string: Use replacestr() in Informatica Expression Transformation to replace singl
18 June 2009
Re: Problem in loading the target: create a file list file.txt which contains the files A,B and C if you run
18 June 2009
RE: How can I remove single quote symbol in a string: Hi, possible way-- using substr function.
18 June 2009
RE: SQ criteria using two table from different database instances: This is what I have implemented. The joiner does not work, because it does
18 June 2009
Implement Update timestamp of old recs and insert new recs: Hi, I have a mapping which reads data from flat file and loads in ora
18 June 2009
Re: Workflow running for longtime: You can kill that on the Infa server On Thu, Jun 18, 2009 at 7:01 AM, accsa
18 June 2009
Workflow running for longtime: We have workflow which is running for than 1 day and still in execution sta
18 June 2009
RE: ftp'ing dynamic filenames in informatica: Hi. I tried putting a dynamic string for Remote Filename: $FTP_OUTPUTFILE b
18 June 2009
How can I remove single quote symbol in a string: Hi gurus, i have a scenario where i have to remove single quote in a string
18 June 2009
Crystal report 2008 server: running report through crystal 2008 server getting RCIRAS0244
18 June 2009
RE: Query Informatica Database for workflows next scheduled run?: Hi.. Probably you have to look at this table... OPB_SCHEDULE_LOGIC. Followi
18 June 2009
Re: Problem in loading the target: Hi, Make sure you have the same structure for all the sources file(A,B,C,..
18 June 2009
RE: Lookup Cache creation takes long time.: Yes, using MD5 is another best option to minimize lookup cache creation tim
18 June 2009
RE: No of fields in flat file: the Best way of doing it to count in Unix based on the delimiter.. Sandee
18 June 2009
RE: No of fields in flat file: Import the file in source analyser and verify OR if you have any scripting
17 June 2009
RE: Problem in loading the target: Hi... You can try it this way... 1. Create Two Mapping Flows. First flow wi
17 June 2009
RE: No of fields in flat file: You can open it in your favorite text editor and count them..... :-)
17 June 2009
RE: Passing a set workflow user_defined variable to pre-session shell command as argument: Although, Informatica has been adding support for variables in the workflow
17 June 2009
RE: Passing a set workflow user_defined variable to pre-session shell command as argument: 8.1.1 I don?t understand why the session task can expand the workflow varia
17 June 2009
No of fields in flat file: Hi, Tell me how to find out the no. of fields in provided flat file. Thanx
17 June 2009
RE: Passing a set workflow user_defined variable to pre-session shell command as argument: What version you on? I do this all the time in Informatica 8.6.1. Works f
17 June 2009
RE: Lookup Cache creation takes long time.: Another option is to use MD5 Checksums. The preferred solution is to store
17 June 2009
RE: SQ criteria using two table from different database instances: Hi Sigalos. I will agree with suggestions given by brain you can prefer tha
17 June 2009
Re: SQ criteria using two table from different database instances: Hi, You can create data base link in data base -1(where table A) to connec
17 June 2009
RE: SQ criteria using two table from different database instances: You cannot access tables, in multiple databases from one source query. (Jus
17 June 2009
Re: Problem in loading the target: Hi Pushpanjali, You can implement this like: Create one mapping with two pi
17 June 2009
RE: PGP Encryption: Hi All, please elobarate more on this topic i am also facing same issue if
17 June 2009
SQ criteria using two table from different database instances: Hi, I am trying to put the where clause in Source Qualifier as follows:
17 June 2009
RE: CMN_1022 Database Driver error: I have tried all the option which I know. I tried the option suggested by y
17 June 2009
Re: CMN_1022 Database Driver error: Please make sure that the ports in SQ are in the same order as in the SQL q
17 June 2009
CMN_1022 Database Driver error: HI ALL, I am getting the following error: CMN_1022 Database Driver Error C
17 June 2009
Problem in loading the target: Hi, I have three source files lets say A, B and C. I would like to load the
17 June 2009
RE: help with mapping logic: Thanks Guys for your response. Its very helpful. I will try this and will
17 June 2009
Query Informatica Database for workflows next scheduled run?: Hello, I would like to be able to query the informatica database directly
17 June 2009
RE: Passing a set workflow user_defined variable to pre-session shell command as argument: Hi... You can give a try with this method. You should try and get read acce
17 June 2009
RE: Can mapping/workflow variables be used in the decision task?: Hi.. You can assign mapping variable value to a workflow variable and then
17 June 2009
RE: flat file with two headers: Hi.. Before this expression add filter tfn to eliminate records which has v
17 June 2009
RE: Deployment group: Now, what types of error were they on your Old Server? Were they related to
17 June 2009
RE: Lookup Cache creation takes long time.: Hi, Persistent Cache would not work. As well as the concurrent cache would
17 June 2009
RE: Concurrent execution of workflow issue: Hi, There is nothing special that you need to do. Though I would suggest y
17 June 2009
RE: Can Informatica 8.6 32 bit be installed in a 64 bit Unix Solaris machine?: Yes, you can do so. ~Harish
17 June 2009
RE: Can mapping/workflow variables be used in the decision task?: Yes, you can use the Workflow Variables in the Decision Task. Regards, ~Har
17 June 2009
RE: flat file with two headers: Rajiv, Another problem popped up with the expression.In my TIME field I fou
17 June 2009
Can mapping/workflow variables be used in the decision task?: Hello everyone, Can mapping/workflow variables be used in the decision task
17 June 2009
Re: Can Informatica 8.6 32 bit be installed in a 64 bit Unix Solaris machine?: Yes, you can install Informatica 8.6 SunOS version (32 bit as well as 64 bi
17 June 2009
RE: Passing a set workflow user_defined variable to pre-session shell command as argument: [Probably this is because $$MYVARIABLE is not getting expanded in the comma
17 June 2009
Concurrent execution of workflow issue: Hi, Recently in this forums i have seen this option(Concurrent execution of
17 June 2009
Can Informatica 8.6 32 bit be installed in a 64 bit Unix Solaris machine?: I have informatica 8.6 32 bit unix version. My unix machine is of solaris 6
17 June 2009
RE: Passing a set workflow user_defined variable to pre-session shell command as argument: Probably this is because $$MYVARIABLE is not getting expanded in the comman
17 June 2009
RE: Lookup Cache creation takes long time.: Hi.. Looking at your requirement, I dont think you can go for persistent ca
17 June 2009
Passing a set workflow user_defined variable to pre-session shell command as argument: Hi I hope you could help me. I have a shell script and I want to use as arg
17 June 2009
RE: Lookup Cache creation takes long time.: @Rajiv: I mentioned I have already commented the Order by clause as it is c
17 June 2009
RE: Lookup Cache creation takes long time.: Guys .. Thanks for the reply. 1. I have to compare all the fields as if th
17 June 2009
RE: Deployment group: Hi divya thanks for ur replay. we have crossverified after restoring, every
17 June 2009
RE: Deployment group: When you are restoring the repository backup to new backup and the process
17 June 2009
RE: help with mapping logic: Use the logic given by Rajiv and following functions and expressions. Use D
17 June 2009
RE: Informatica error: [PCSF_10007]: @Rishi Good to know that you were able to install and configure informatica
17 June 2009
RE: help with mapping logic: get the maximum date by aggregator transformation and then get date differe
17 June 2009
Deployment group: Hi all, we have recently migrated prod server, just we have taken the backu
17 June 2009
RE: help with mapping logic: Hi.. Do the following. Read source and put override sql select max(date) f
17 June 2009
RE: Lookup Cache creation takes long time.: Hi... Also you can try use concurrent cache creation to fasten cache creati
17 June 2009
RE: RE:Read-only mapping?: Some times when you lock your mapping from one system, you cant open that s
17 June 2009
RE: Read-only mapping?: Thanks for the suggestion. It helped me, on exporting and re-importing the
17 June 2009
RE: Lookup Cache creation takes long time.: Hi.. Dont create cache always inside mapping if lookup is big and not chang
17 June 2009
RE: Persistent caching: Hi.. Enabling persistent cache saves most of caching time during session ru
17 June 2009
RE: Lookup Cache creation takes long time.: Hi, If your source is not changing rapidally you can go for the Persistence
17 June 2009
RE: Persistent caching: Humm.. Persistence cache gives you speed but take the resources as well. Yo
17 June 2009
help with mapping logic: Hi I need to check the maximum date in a table as a part of ETL and see if
17 June 2009
RE: Informatica error: [PCSF_10007]: Hi, humm..seems to be an interesting and un-orthodox solution. Spywares, Fi
17 June 2009
Lookup Cache creation takes long time.: Hi, One of my lookup table has huge data and there is an SQL override also,
17 June 2009
RE: Import two xml file into same process: Hi, I think you need to explore the concept of File List. You need to use
17 June 2009
RE: Copying repository users and groups: Hi, Take the Repository Backup and Restore the same to another Repository.
17 June 2009
Copying repository users and groups: May be this question is trivial. But how do I copy users and groups from re
16 June 2009
RE: Informatica error: [PCSF_10007]: @ Rajiv chitlur I tried many times...still got the same error...I think som
16 June 2009
Persistent caching: Hi, i have 100's of mappings wherein I have to test the performance of enab
16 June 2009
Import two xml file into same process: I am new to informatica. i have worked alot on SSIS packages. I was thinkin
16 June 2009
Re: Read-only mapping?: Did you try exporting and reimporting the mapping? Please check the reposit
16 June 2009
RE: Read-only mapping?: Thanks guys. I'm pretty sure the mapping isn't locked by anyone else, thou
16 June 2009
RE: The Workflow has failed While posting data in SAP . It Shows Exception System Failure.: The file name is dev_rfc.trc
16 June 2009
RE: The Workflow has failed While posting data in SAP . It Shows Exception System Failure.: Hi, Please post the full error message. Also Check the file dev_rfc.ini in
16 June 2009
Re: number formate: hi! your problem is not clearly stated... On Mon, Jun 15, 2009 at 3:19 PM
16 June 2009
Re: EBCDIC to ASCII using Informatica: Hi, Informatica will automatically take care of that, Just use your VSAM co
16 June 2009
RE: Differences between 8.6.0 and 8.6.1?: You can also go into your support account and download the latest HotFix do
16 June 2009
EBCDIC to ASCII using Informatica: How to read (convert) EBCDIC with COMP-3 decimals in Informatica?
16 June 2009
Re: PowerCenter Connect. for SAP R/3: Madan is correct. On Tue, Jun 16, 2009 at 6:16 PM, mohanyerra via informati
16 June 2009
Re: PowerCenter Connect. for SAP R/3: If you have SAP definition in your mapping, You have to know how to generat
16 June 2009
PowerCenter Connect. for SAP R/3: I need to extract data in SAP R / 3 via PowerCenter Connect. I need to unde
16 June 2009
RE: Primary key at informatica level: Hi Tanmay. if i declare primary key at informatica level but not at databas
16 June 2009
Primary key at informatica level: Hi Experts, I want to know if i declare primary key at informatica level bu
16 June 2009
RE: number formate: Yes..you can do it. But we can assist your better if you put in clear words
16 June 2009
RE: Differences between 8.6.0 and 8.6.1?: Hi, How about working on the given suggetions by Rajiv. As of now, there no
16 June 2009
RE: The Workflow has failed While posting data in SAP . It Shows Exception System Failure.: Hi, It seems that your session is getting succeded due to which your workfl
16 June 2009
RE: document template: Hummm.what kind of the document you are looking for? What is the informatio
16 June 2009
RE: Using excel 2003 worksheet(*.xls) as a source.: Define area in Excel means: In Excel go to Insert--->Name--->define. Here y
16 June 2009
RE: Run the same session in pararel with different parameter files: Hi, You can also work with the concurrent workflows concept, where it does
16 June 2009
RE: Using excel 2003 worksheet(*.xls) as a source.: Hi Rishi, You need to create an user DSN for the excel file, which you want
16 June 2009
RE: Read-only mapping?: Rajiv is correct. Ensure that the mapping is not in open state by any othe
16 June 2009
RE: Read-only mapping?: Hi.. The mapping is being edited by somebody and it is still open. So it ha
16 June 2009
WSDL SOAP calls: Please help me get started with SOAP calls using WSDL transformation. Is th
15 June 2009
Read-only mapping?: In trying to modify a mapping, I'm getting the message "The currently open
15 June 2009
Re: document template: Amar, Please post your question appropriately is it Web services or wed ser
15 June 2009
RE: document template: Huh?
15 June 2009
RE: Using excel 2003 worksheet(*.xls) as a source.: Personally, I would still go with the delimited route, either: 1. Comma d
15 June 2009
Re: Using excel 2003 worksheet(*.xls) as a source.: if u want use a delimited file as a source.. no need to convert it into a e
15 June 2009
Re: The Workflow has failed While posting data in SAP . It Shows Exception System Failure.: Check if SAP server is up and running On Fri, Jun 12, 2009 at 4:59 AM, accs
15 June 2009
Re: Writing as BLOB in SQL Server: I think Infa supports TEXT datatype(Similar to BLOB) of SQL Server On Thu,
15 June 2009
RE: Run the same session in pararel with different parameter files: Yup. 1. Create session, make it reusable. 2. Create two workflows, each u
15 June 2009
RE: Connect Informatica from UNIX to Windows: What do you mean "Connect both servers"? Are you referring to running Inf
15 June 2009
document template: i need a stand document fromate for my wed services, can any one help that
15 June 2009
number formate: i have a situation where my input file format is.... it is a 15 digete n
15 June 2009
RE: RE:Using excel 2003 worksheet(*.xls) as a source.: Hi, Can you please elaborate this - Define the area of the Excel sheet & im
15 June 2009
RE: Using excel 2003 worksheet(*.xls) as a source.: Either Define the area of the Excel sheet & import the file into Informatic
15 June 2009
Using excel 2003 worksheet(*.xls) as a source.: Hi, I need to use an excel file as a source for one of my mappings. I don't
15 June 2009
Connect Informatica from UNIX to Windows: Connect Informatica from UNIX to Windows Informatica server is in Unix env
15 June 2009
RE: How abort when error count exceeded...?: Hi all, Sorry for late reply. There is no problem with parameter file path
15 June 2009
RE: Number to date datatype change: Hi Sohan, There is some correction to my previous expression which i update
14 June 2009
RE: Number to date datatype change: Hi Sohan, Correction to previous expression Create a expression transformat
14 June 2009
RE: Number to date datatype change: Hi Sohan, Small correction in expression: Create a expression transformatio
14 June 2009
RE: Number to date datatype change: Hi Sri, I tried ur solution before it doesn't work. and also for ur solutio
14 June 2009
Re: Number to date datatype change: Hi Sohan, Create a expression transformation taking input port as Go_date i
14 June 2009
RE: Informatica error: [PCSF_10007]: I tried reinstalling again using tips given above. But still got the same e
14 June 2009
Run the same session in pararel with different parameter files: Hi gurus, Is it possible some how to run 1 sessions in paralel with 2 diffe
13 June 2009
Number to date datatype change: I have relational source with a field Go_date in number datatype ..it comes
13 June 2009
Re: CONCAT month, day & year and also take of blank and NULL: Hi LaL, You can do something like this if any part of the date_filed (YY or
13 June 2009
Differences between 8.6.0 and 8.6.1?: We are upgrading from PowerCenter 7.1.4, and I am trying to decide between
12 June 2009
RE: CONCAT month, day & year and also take of blank and NULL: You are only checking to see if Year (HX_DTC_YR) is null, what happens if y
12 June 2009
RE: CONCAT month, day & year and also take of blank and NULL: Hi Lalsalam, We can not have NULL or BALNK values for any part(DD or MM or
12 June 2009
CONCAT month, day & year and also take of blank and NULL: I have to concat 3 string fields each with month, day & year and make it in
12 June 2009
RE: Hot Backup: Hi.. I have not heard about incremental repo backups. In my project, I have
12 June 2009
RE: Hot Backup: No there is no way to do incremental backups. If you don't care about r
12 June 2009
RE: File Watcher Process: Please also petition your Informatica Admin to open up an enhancement reque
12 June 2009
The Workflow has failed While posting data in SAP . It Shows Exception System Failure.: The Workflow has failed While posting data in SAP . It Shows Exception Sys
12 June 2009
RE: Lookup Property : Ignore in comparison: Hi Harish, Ignore in Comparison: Informatica compares the values in all lo
12 June 2009
RE: Lookup Property : Ignore in comparison: Hi Rishi, Ignore Null Inputs for Updates: Select this property when you don
12 June 2009
RE: Hot Backup: Dear Divya, Thanks for your Quick Response is there any option which allow
12 June 2009
RE: Informatica error: [PCSF_10007]: Hi, Just to ensure that you have used the correct users: Repository User is
12 June 2009
RE: Lookup Property : Ignore in comparison: Hi, As stated the above properties used while working with Dynamic LKP. Ign
12 June 2009
RE: Event Wait Handling: Hi, For unix, you can go ahead with the script to check for the existence o
12 June 2009
Event Wait Handling: Hi , I have a requirement as below . NDM transfers a file daily in
12 June 2009
RE: Aggregate and lookup problem ( getting the biggest value): Hi... Probably you convert the second field to correct date format and then
12 June 2009
RE: i have single column col1: Hi... Sort on first field, add expression, compare records based on first f
12 June 2009
RE: Informatica error: [PCSF_10007]: Hi.. If that is the case then there is some issue related to connecting to
12 June 2009
Multiple occuring element in XML: I have a source flat file & an xsd which i'm using in xml generator. Now so
12 June 2009
i have single column col1: 1 a 1 b 1 c 2 d 2e 2 f i have to load to target 1 a b c 2 d e f
12 June 2009
RE: Informatica error: [PCSF_10007]: Hi.. If that is the case then there is some issue related to connecting to
12 June 2009
Re: Aggregate and lookup problem ( getting the biggest value): Hi, I've tried your suggestion for lookup so many times ( may be a hundred)
12 June 2009
On DAC: Hi All, One serious issue on DAC. I have exported all the execution plans i
12 June 2009
RE: Informatica error: [PCSF_10007]: Hi Rajiv What do you mean by repository user? Is it the user which is used
12 June 2009
RE: Lookup Property : Ignore in comparison: Hi. Ignore Null Inputs for Updates is commonly used/enabled with dynamic lo
12 June 2009
Lookup Property : Ignore in comparison: Hi All, In informatica 8.6 there are check boxes for "Ignore in comparison"
12 June 2009
RE: Varying Columns for rows in the same file: Hi Nick and Dan, Thanks for the reply;. For now, I'm going ahead with the a
12 June 2009
RE: Informatica error: [PCSF_10007]: Hi. Recently I installed 8.6.0 on Windows XP SP4. I was hitting lllar kind
12 June 2009
RE: Informatica error: [PCSF_10007]: Hi All I also faced this issue many times and I had reported it to the foru
12 June 2009
RE: Informatica error: [PCSF_10007]: I have seen this error post many times, and fortunately I have never encoun
12 June 2009
RE: File Watcher Process: Create a shell script and run the workflow through pmcmd after the ABC* fil
12 June 2009
RE: File Watcher Process: Hi. Instead of Event Wait, you can try calling a script from command task.
12 June 2009
File Watcher Process: Hi, I need file watcher process. I know there is Event Watcher looks for o
11 June 2009
RE: How to keep target data same as input from Occurs Cobol source: You can just edit the source qualifier that was generated. There is no nee
11 June 2009
Informatica error: [PCSF_10007]: Error - [PCSF_10007] pls help hey I installed informatica 8.1.1 on vista 32
11 June 2009
Re: How abort when error count exceeded...?: Can you try $ParamSessionErrorLimit in the session settings instead of hard
11 June 2009
RE: Varying Columns for rows in the same file: Nick, we just implemented the same very solution a few weeks ago. Works lik
11 June 2009
RE: Copying multiple relational/ODBC (workflow manager) connections from DEV to QA: I use to follow the method that GovindPullat suggested. Just create a dummy
11 June 2009
RE: How to automatically modify naming conventions/data types etc. ?: We've changed the XML for years :-) If you do it, just test your changes re
11 June 2009
RE: How to keep target data same as input from Occurs Cobol source: That's one solution. That means that the Cobol copybook has to change befor
11 June 2009
RE: Hot Backup: pmrep is the command and you can use the following options: backup -o
11 June 2009
RE: Repository service failed to connect to the database within the database connection timeout of 180 seconds: The error is clearly mentioned in your log: ERROR Tue Jun 9 15:00:45 2009 2
11 June 2009
RE: How to automatically modify naming conventions/data types etc. ?: I think its better to change them manually instead of changing the XML. It
11 June 2009
RE: Varying Columns for rows in the same file: The three output and remerge will probably work provided, in the first pass
11 June 2009
RE: How to delete the empty row: Trim both the columns using LTRIM/RTRIM, concatenate them and in a filter,
11 June 2009
RE: Informatica Query On database: Hi You can check the session log for a session and all the queries can be
11 June 2009
RE: How abort when error count exceeded...?: Try using hardcode value 2, and see if it works. I am not sure if we can us
11 June 2009
RE: How to keep target data same as input from Occurs Cobol source: Don't use normalizer. Your source should have 12 individual columns... just
11 June 2009
RE: How abort when error count exceeded...?: Also see if defining it in the workflow variable section helps. -- Brian
11 June 2009
RE: How abort when error count exceeded...?: Hi Ammet, It could be a reason: make sure you mention the parameter file pa
11 June 2009
RE: How lookup transformation is passive: Hi Anila, Forgot to clarify your doubt. Q)A sorter has the same number of r
11 June 2009
RE: How lookup transformation is passive: Hi Anila, Yes your assumption is correct, In another way active transforma
11 June 2009
How abort when error count exceeded...?: Hi All, I am trying to stop the session when "Stop on Errors" values dynami
11 June 2009
RE: Varying Columns for rows in the same file: Talking about the source - they are all tables.I have written the mapping t
11 June 2009
RE: How lookup transformation is passive: Hi All, I've heard most of us defining a passive transformation as one that
11 June 2009
Writing as BLOB in SQL Server: Hi Gurus, My requirement - Read the contents of a file (that may go up to 2
11 June 2009
RE: How to keep target data same as input from Occurs Cobol source: No. I can't. My target table defined differently. Like: Month1 Month2 M
11 June 2009
RE: How lookup transformation is passive: Thank you divya and srikanth for clarifying me Till now iam doubt about the
11 June 2009
RE: how to write this expression?: Hi Sohan, Your expression can be like this V_CHK_M_SIGNAL= IIF(DATE_DIFF( S
11 June 2009
Re: Copying multiple relational/ODBC (workflow manager) connections from DEV to QA: If you have a versioned repository, and have hardcoded all those connection
11 June 2009
RE: IIF and create flag in expression transformation: Hi. Probably could be like this... Z_Man_Var=IIF(Z='Man','Man','Boy') Z_Wom
11 June 2009
RE: IIF and create flag in expression transformation: Hi Aronmelon, Some of my explanation is missing in previous thread. If you
11 June 2009
Re: How lookup transformation is passive: Hi Active transformation means it should change the no of records before
11 June 2009
RE: How lookup transformation is passive: Lookup is a passive transformation because it will return a value if a matc
11 June 2009
RE: IIF and create flag in expression transformation: Hi aronmelon, Can you provide me some clarification regarding your question
11 June 2009
SAP R/3 4.5B and Informatica 8.6.1: All, We are using informatica 8.6.1 and we have to connect to the source
11 June 2009
RE: How lookup transformation is passive: Yes Srikanth, You are right. We consider this as passive because it always
11 June 2009
How lookup transformation is passive: Hi, Can some one explain me how can we consider lookup as passive transform
11 June 2009
RE: Static Connection information is inappropriate to create a valid Database Handle: Hi. Ensure that you have mentioned relational connection for SQL transforma
11 June 2009
RE: SPC_10008 error messages......: Hi.. Refer informatica help "Using pmcmd" and ensure all PMCMD environment
11 June 2009
RE: Informatica session fails with complete load.: Hi.. Sort data before passing to joiner tfn. Probably you can also look at
11 June 2009
RE: SPC_10008 error messages......: Hi, Ensure you have the correct Environmental Variable settings for your PM
11 June 2009
RE: Informatica session fails with complete load.: Hi, Try executing the same with the verbose mode of the session and you wil
11 June 2009
Informatica session fails with complete load.: I am running a table which has 2560 records and after the session run the e
11 June 2009
RE: Static Connection information is inappropriate to create a valid Database Handle: Hi, Try giving the direct connection name in the Relational Connection inst
11 June 2009
RE: How to keep target data same as input from Occurs Cobol source: Hi, Did you try importing the source as target in your Target Analyzer. Thi
11 June 2009
RE: Static Connection information is inappropriate to create a valid Database Handle: Hi, I feel that you haven't declared the values for $Source & $Target pa
11 June 2009
Static Connection information is inappropriate to create a valid Database Handle: Hi All, I have created an SQL Transformation and where I could find the bel
10 June 2009
How to keep target data same as input from Occurs Cobol source: I have a target table in Oracle where I need to populate with data from the
10 June 2009
SPC_10008 error messages......: Hi there, We are encountering the following error in the Inf 8.5 environmen
10 June 2009
RE: how is the union transformation active transformation?: Hi All, In union transformation there is option called is active which will
10 June 2009
Informatica Power Exchange LogFile Path: Hi, I have created datamap in power exchange,When i tried to execute its
10 June 2009
RE: Microsoft Access as a source for Informatica PowerCenter: Good to know that the problem is resolved. Regards, ~Harish
10 June 2009
RE: Microsoft Access as a source for Informatica PowerCenter: well, I created that as user DSN, too bad... Thanks for the tip, it resolve
10 June 2009
RE: Hot Backup: Hi, Refer to the section Command Line Reference--> PMREP Command Reference
10 June 2009
RE: Informatica 8.x Implementation Recommendations: Hi, In the absence of the High Availability, you would have to stick the ba
10 June 2009
RE: Microsoft Access as a source for Informatica PowerCenter: Hi, Have you created the system DSN for the same. As you need that to be us
10 June 2009
RE: On DAC: Hi, Well, I am not having much idea about DAC. As you mentioned, that 1 or
10 June 2009
RE: Repository service failed to connect to the database within the database connection timeout of 180 seconds: Hi, Pls. check the account is not locked in DB with which you are trying to
10 June 2009
RE: Microsoft Access as a source for Informatica PowerCenter: to be more precise, I have created an relational connection (ODBC) on the P
10 June 2009
RE: On DAC: I think the problem is solved like i am executing 1 or 2 or 3 subject areas
10 June 2009
Hot Backup: how to take Incremental backup of Repository by command line
10 June 2009
Microsoft Access as a source for Informatica PowerCenter: Hi, I can't achieve to create a source to a microsoft Access database. I've
10 June 2009
RE: How to automatically modify naming conventions/data types etc. ?: I understand, however is there not any "unofficial way" how to change prefi
10 June 2009
Repository service failed to connect to the database within the database connection timeout of 180 seconds: Hi all, we have a situation like this, when we tried to run the workflow w
10 June 2009
RE: Informatica 8.x Implementation Recommendations: Hi,If we are not licensed to use the high availabilty option in informatica
10 June 2009
RE: Expression Confusion: Hi.. Filter condition should be NOT ISNULL(DEL_FLAG) /Rajiv
10 June 2009
RE: IIF and create flag in expression transformation: Hi.. Try this.... Z_Man_Var=IIF(Z='Man','Man','Boy') Z_Woman_Var=IIF(Z='Wom
10 June 2009
RE: Expression Confusion: Yes...it is correct...and you should put ISNULL(DEL_FLAG) in the filter /Ra
10 June 2009
RE: Expression Confusion: Rajiv, Is this the expression DEL_FLAG=IIF(NOT ISNULL(A),A, IIF(SUBSTR(B,1,
10 June 2009
RE: IIF and create flag in expression transformation: rajiv, Here I will explain Check if a field L is greater than field M if y
10 June 2009
RE: IIF and create flag in expression transformation: HI.. What flag value to be set if Z='Man'. According to your statement your
10 June 2009
RE: IIF and create flag in expression transformation: Rajiv, Thanks a lot. I haven't tried that but hope it works. But a quick qu
10 June 2009
RE: IIF and create flag in expression transformation: Hi.. Try this...but I have changed Woman to Girl for second statement, can
10 June 2009
RE: How to delete the empty row: Hi.. Check the content of the field before passing to the target or can app
10 June 2009
RE: Expression Confusion: Hi.. Try this.. DEL_FLAG=IIF(NOT ISNULL(A),A, IIF(SUBSTR(B,1,2)='ME',IIF(L
10 June 2009
IIF and create flag in expression transformation: I need to set the following in an expression and create a flag...can i get
9 June 2009
How to delete the empty row: I have a expression,here I have two output fieldA and fieldB With fieldA:fi
9 June 2009
RE: Expression Confusion: Hi Rajiv, Your expression is working. But I am facing an unusual problem in
9 June 2009
RE: how to write this expression?: I am sorry , even though I got the prior month expression from you 'll I co
9 June 2009
RE: Init Logistic Cockpit: You may want to try the SAP BW or ABAP group for this one.
9 June 2009
RE: Informatica Query On database: Huh? Which database are you talking about? There is the repository that co
9 June 2009
RE: Informatica Error when Sourcing Too Many Rows: You are running out of disk space for the temp files created by the aggrega
9 June 2009
RE: Print File to Flat File Format: Use expression variables to store the current number and an accumulating co
9 June 2009
RE:Print File to Flat File Format: I Tried to use an expression for concatenate the parts until the number cha
9 June 2009
Informatica Query On database: Could anyone please tell me the way to see the query which informatica fire
9 June 2009
RE: How to load one column of different group to one target but in different columns?: You can sort on col3 and then use an aggregator and group by col3 and use t
9 June 2009
RE: Dynamic Lookup: @ menarun Thanks a lot . That was an awesome explanation . Regards , Venkat
9 June 2009
Stored Procedure Error: I am getting below error while using stored procedure from Informatica . Fu
9 June 2009
RE: Aggregate and lookup problem ( getting the biggest value): You can sort on the key first and then on date field and in the aggregator
9 June 2009
RE: Scheduler in Informatica: Please let me know if we can avoid the this manual step and set to run the
9 June 2009
RE: CLOB's in Power Center Transformations: So how did you have the datatype and precision defined in the transformatio
9 June 2009
RE: Varying Columns for rows in the same file: You have not told anything about the source? Is it a table or file and how
9 June 2009
RE: Varying Columns for rows in the same file: Hi, you can easily do it Using Unix, by using cut , wc -l , and sed comma
9 June 2009
Varying Columns for rows in the same file: Hi Gurus, Have a question. I have a file that should be written in the form
9 June 2009
RE: Setting mapping variable value in a fiter transformation: Hi, SriKanth and Bineet are correct. You need to use the EXP Transformaton
9 June 2009
Init Logistic Cockpit: Hi, I need to execute init for Logistic Extract Structure Cockpit. In my s
9 June 2009
RE: Setting mapping variable value in a fiter transformation: V_LAST_EXTRACT_DATE=SETVARIABLE($$LAST_EXTRACT_DATE, TRANSACT_DATE) and cre
9 June 2009
RE: Unstructured Data Option Metadata Extensions: That's really strange. Try recreating the same from fresh. Regards, ~Haris
9 June 2009
RE: Setting mapping variable value in a fiter transformation: Hi Subrahmanian, What Bineet said is correct. WE can not create expression
9 June 2009
RE: Header/Footer Handling without using Shell Script...: Hi.. Do the following. 1. Read the file in first flow, divert Header, D
9 June 2009
Header/Footer Handling without using Shell Script...: Guys, This questions asked many time in this forum, but i need solution wit
9 June 2009
RE: Flat file to Flat file load: You can use indirect file option if the files are identical in structure. o
9 June 2009
RE: how to write this expression?: hi try like this IIF(DATE_DIFF( MY_DATE, SYSDATE, 'MM' )>3, 'Y','N') Re
9 June 2009
RE: how to write this expression?: v_port1: IIF(DATE_DIFF( SYSDATE,MY_DATE, 'MM' )>3, 'Y','N') Use variable po
9 June 2009
RE: how to write this expression?: Hi Sohan, Below is expression to find out if my_date is prior to 3months fr
9 June 2009
RE: Unstructured Data Option Metadata Extensions: The source is my flat file which has the path of the file(txt file) and the
9 June 2009
RE: Copying multiple relational/ODBC (workflow manager) connections from DEV to QA: I think you can export and import connection objects from repository manage
9 June 2009
RE: Scheduler in Informatica: I dont think it is a limitation, but it is a feature which informatica is p
9 June 2009
RE: Differences between 8.6.0 and 8.6.1?: Hi. Best way is refer help. If you open any help guide of latest version, f
9 June 2009
RE: Scheduler in Informatica: Hi. I have written a tip in "Tips n Tricks" section in Technet.informatica
9 June 2009
RE: Flat file to Flat file load: Hi. You can do it two ways... 1. You can append the output to the target fi
9 June 2009
RE: Copying multiple relational/ODBC (workflow manager) connections from DEV to QA: Hi. Create relational connections with same name in QA environment also. Yo
9 June 2009
how to write this expression?: I have to write this expression: Check if my_date is earlier than 3months p
8 June 2009
RE: How can I tell what will be the next value generated by a sequence generator when the workflow is run again ?: If you open the sequence generator in mapping /transformation designer, you
8 June 2009
RE: flat file with two headers: Rajiv Chitlur, It was perfect.Thank you so much.
8 June 2009
RE: Create a flat file: Thanks Rajiv it worked.
8 June 2009
RE: How to automatically modify naming conventions/data types etc. ?: Yeah... give it to the guy who made up the new rules and make him do it. Un
8 June 2009
RE: Copying multiple relational/ODBC (workflow manager) connections from DEV to QA: Hi Nick. I understand that. But I will be using same DEV database across QA
8 June 2009
RE: Cureent value of mapping variable in the repository: You can see a mapping variable value using the debugger.
8 June 2009
RE: Copying multiple relational/ODBC (workflow manager) connections from DEV to QA: You don't 'copy' the connections... you define new ones in the new environm
8 June 2009
RE:CLOB data returned in a stored procedure transformation: Yep! When you import it, it defaults to TEXT (0). --- On Mon, 6/8/09, ngal
8 June 2009
Copying multiple relational/ODBC (workflow manager) connections from DEV to QA: Hi, I have very generic & useful question this time We are ready with DEV e
8 June 2009
RE: Uisng lst files for indirect read: If you on 8.5 there should be a port from the SQ that will provide the file
8 June 2009
RE: CLOB data returned in a stored procedure transformation: I havn't tried receiving CLOBs through a SP call... is the receiving port d
8 June 2009
Re: Binary Log File: You know it, but the ascii one doesn't have the information I need, the tim
8 June 2009
Re: Binary Log File: In session properties, select "Write Backword compatible session log files"
8 June 2009
Re: Scheduler in Informatica: This is basic limitation of Informatica scheuler. It will unschedule the wf
8 June 2009
Cureent value of mapping variable in the repository: One way to tell the current (persisted) value of a mapping variable is by q
8 June 2009
Re: CLOB's in Power Center Transformations: I am not very sure about stored proc.. but I have used CLOBS as return port
8 June 2009
Scheduler in Informatica: Hi Gurus, I am using Informatica 8.5.1 and need to schedule my daily work f
8 June 2009
CLOB data returned in a stored procedure transformation: I have a Oracle Stored procedure that returns a CLOB data type. I've added
8 June 2009
CLOB's in Power Center Transformations: I have a Oracle stored proc that returns a CLOB. I have imported it into a
8 June 2009
Re: Setting mapping variable value in a fiter transformation: SETVARIABLE can be used in an expression transformation On Mon, Jun 8, 2009
8 June 2009
Flat file to Flat file load: All, I need to create a flatfile. For that I have 2 input flat file. I need
8 June 2009
Differences between 8.6.0 and 8.6.1?: We are upgrading from PowerCenter 7.1.4, and I am trying to decide between
8 June 2009
How to automatically modify naming conventions/data types etc. ?: Hello, is there a way to collectively modify prefix in name of all sessions
8 June 2009
Setting mapping variable value in a fiter transformation: Given - (1) a mapping variable called $$LAST_EXTRACT_DATE (2) a filter tran
8 June 2009
RE: How can I tell what will be the next value generated by a sequence generator when the workflow is run again ?: What does it matter? The next time the process runs it will not be the next
8 June 2009
RE: Print File to Flat File Format: Treat the file as fixed width and define two fields, one for the number and
8 June 2009
RE: Uisng lst files for indirect read: Generally these types of business logics are used where a single target is
8 June 2009
Binary Log File: Hi all. Informatica usually generates two files for logging the sessions, o
8 June 2009
Uisng lst files for indirect read: I have multiple files that I need to read as the source to an informatica m
8 June 2009
RE:Print File to Flat File Format: yes sumit, the file is text file --- On Mon, 8/6/09, SumitNiv via informati
8 June 2009
RE: Unstructured Data Option Metadata Extensions: Hi, When the input type is File, the Complex Data transformation receives t
8 June 2009
RE: Unstructured Data Option Metadata Extensions: I am using Input port as File Output port as Buffer. The design of my ma
8 June 2009
RE: Unstructured Data Option Metadata Extensions: Hi, Pls. check what type of input port you are using, Buffer or File? Regar
8 June 2009
RE: Steps to move code in Version enabled repository: Yeah, you are correct. The best source of information to understand the pro
8 June 2009
Unstructured Data Option Metadata Extensions: My mapping is not getting validated while i am trying to use unstructured d
8 June 2009
RE: Informatica Data analyser: Hi, Amin: Are you able to solve the problem? Did you find any solution for
8 June 2009
RE: On DAC: Hi, Any further update or futher informaton available on this? Or Is the pr
8 June 2009
RE: Lookup enabled to use cache: Hi, First of all you need to understand how does the LKP Transformation wor
8 June 2009
RE: Lookup enabled to use cache: Hi.. Persistant Cache is built once across static dimensions. For instance
8 June 2009
RE: Unable to contact the OpenLink License Manager: Hi, Ensure that you have used the correct ODBC Driver for the Informix conn
8 June 2009
RE: Unable to update a record: Hi, It have been better if you would have shared the error mesg that you ar
8 June 2009
RE: RE:SetCountVariable function is not working properly.: Thanks Srikanth, its working now. ________________________________________
8 June 2009
RE: SetCountVariable function is not working properly.: See if you can go with this: Note: Dont initialize $$Max_ID in parameter fi
8 June 2009
RE: SetCountVariable function is not working properly.: Hi Vikas, Try wih this: ID_MAX_v ---> IIF( ISNULL($$MAX_ID) OR 0, 1,SETCOUN
8 June 2009
RE: RE:SetCountVariable function is not working properly.: Hi Srikanth, When your data type is integer then you will be able to see th
8 June 2009
RE: SetCountVariable function is not working properly.: Thank you sumit just now i verified COUNT aggregation available for intereg
8 June 2009
Unable to update a record: Hi folks, I have to update the below record into data base, but I couldn'
8 June 2009
RE: SetCountVariable function is not working properly.: Hi Sumit, Iam using informatica 8.5, i see only MAX/MIN aggregation types f
8 June 2009
RE: Print File to Flat File Format: Hi Satish, What is the extension of that printable formated file? Is that f
8 June 2009
RE: RE:SetCountVariable function is not working properly.: Hi Srikanth, Thanks for responding. Actually i m working on Infra 8.1, ther
8 June 2009
Unable to contact the OpenLink License Manager: I'm running a workflow in informatica PC 8.5.1 two of the sessions runs suc
8 June 2009
RE: SetCountVariable function is not working properly.: Hi Vikas, Can you check whether you have set the aggregation type of the ma
8 June 2009
RE: How can I tell what will be the next value generated by a sequence generator when the workflow is run again ?: Hi, There is another constraints as well, if the SEQ G property of "Number
8 June 2009
RE: How can I tell what will be the next value generated by a sequence generator when the workflow is run again ?: Hi Subramanian, The nextavl in sequnce generator may also depends on number
8 June 2009
RE: How can I tell what will be the next value generated by a sequence generator when the workflow is run again ?: Hi, The given suggestion by Rajiv would work well, if the RESET property of
8 June 2009
RE: SetCountVariable function is not working properly.: Hi Vikas, I think some of your explanation is missing in the thread at the
8 June 2009
RE: session expired: humm..this problems comes due to idle sessions or less timeout values set f
8 June 2009
RE: SuperScript characters missing: The code page seems to be the problem. As the standard Windows code page do
8 June 2009
RE: SetCountVariable function is not working properly.: Hi Divya, My source is like this. Key Date --------- ---
8 June 2009
Steps to move code in Version enabled repository: Hello All, I just searched this group to find the steps involved and differ
8 June 2009
Re: SuperScript characters missing: use the valid code page for this... in source assign the code page to MICRO
7 June 2009
Re: session expired: just refresh the mapping.. disconnect from that folder in workflow manager
7 June 2009
Print File to Flat File Format: Hi, I am having a file in printable format and i need to convert it into Fl
7 June 2009
RE: How can I tell what will be the next value generated by a sequence generator when the workflow is run again ?: Hi... If sequence value is populated into target table, then you can take m
7 June 2009
RE: Create a flat file: Hi. Refer this post...it has exactly same logic meeting your requirements.
7 June 2009
How can I tell what will be the next value generated by a sequence generator when the workflow is run again ?: I have run a workflow that contains a sequence generator to create values f
6 June 2009
Create a flat file: I have a source a id:compname:field 23:Rageis:Role 43:Yahooi:Role 54:googl
6 June 2009
RE: Informatica loop?: Hi.. Try the following... After decision task add two command tasks. cmd1
6 June 2009
RE: flat file with two headers: Hi.. Try this... output = IIF (v_out = 'N' and TIME='day',NAME ||'|' || ADD
6 June 2009
RE: Informatica Target Table Name Overide: This is so dumb. The fix is so trivial, i wonder why Informatica has not do
6 June 2009
RE: Failed to connect to Repository: you should get the server name ,and repostive server name ,and password
6 June 2009
Lookup enabled to use cache: Hi, When the lookup is enabled to use cache, is that lookup query is
6 June 2009
RE: Informatica 8.6.1 Hangs: I have installed and successfully ran the wfs, never had hanging issue. Is
5 June 2009
RE: Failed to connect to Repository: I saw this suggestion elsewhere. I've tried this one too!! :-((
5 June 2009
Re: Failed to connect to repository: Hi, Check the following options. - Install the Informatica software with Ty
5 June 2009
RE: Fast export reader error.: ? Clean the Temp files in informatica. ? Clean the cache in informatica. ?
5 June 2009
RE: Failed to connect to repository: Hi Karthick, Thanks for your quick reply. I had tried that umpteen times.
5 June 2009
Re: Failed to connect to repository: Hi It might be the problem with your oracle login credentials. Please make
5 June 2009
Failed to connect to repository: Hi, I'm trying to install Power Center 8.6 on XP with Oracle 10g. I've inst
5 June 2009
RE: Informatica loop?: You can write a sql script and wrap with shell script to check your paramet
5 June 2009
RE: flat file with two headers: Rajiv, Filter would not work..if I get the output from output = IIF (v_out
5 June 2009
session expired: when i run the workflow,i'm getting the error that session is expired.what
5 June 2009
RE: SuperScript characters missing: It seems that your source is a flat file. Are you loading to relational tab
5 June 2009
Informatica loop?: I'm trying to make a session loop in Informatica. I need to run a session
5 June 2009
RE: SetCountVariable function is not working properly.: The above explanation is not clear. Can you elaborate a bit. Are you using
5 June 2009
RE: Workflow Logs - How to remove INFO 'VAR_27014 [Warning! Found an unused name and value pair in parameter file .]': The warning is coming because you have defined a parameter for DBConnection
5 June 2009
RE: flat file with two headers: Hi Rajiv, I used this as given by Bala...was looking perfectly fine..I woul
5 June 2009
Workflow Logs - How to remove INFO 'VAR_27014 [Warning! Found an unused name and value pair [] in parameter file [].]': Hi, this is my first post here, so plz excuse any mistakes :) I'm using Inf
5 June 2009
SetCountVariable function is not working properly.: Hi All, My scenario is that I am trying to implement Sequence Generator wit
5 June 2009
RE: Error while fetching the data from SQL server: Hey, this time it seems to be progressive now, as you said that 59 out of 1
5 June 2009
SuperScript characters missing: I have a data in the source for which i have a superscript value (TM) Trade
5 June 2009
RE: flat file with two headers: Hi. Based on your requirement you can still go with same mapping. If the re
5 June 2009
RE: Error while fetching the data from SQL server: Hi Harish, I even tried creating a new mapping by importing the source from
5 June 2009
RE: flat file with two headers: Hi, My requirement changed and I am facing a problem My source file is thi
5 June 2009
RE: Flat File Target [Target_TransControlFile_Dept] FileName Port is not supported with connection or merge option.: Hi. If your source is flat file and if you want to capture its name and use
5 June 2009
RE: Flat File Target [Target_TransControlFile_Dept] FileName Port is not supported with connection or merge option.: Hi Rajiv, What do you mean by CurrentlyProcessedFileName, can you pls elabo
4 June 2009
RE: Flat File Target [Target_TransControlFile_Dept] FileName Port is not supported with connection or merge option.: Also my target is flatfile and i have only one target file.
4 June 2009
RE: Flat File Target [Target_TransControlFile_Dept] FileName Port is not supported with connection or merge option.: Hi I have resolved the new record vs old record issue, but the issue with "
4 June 2009
RE: Reading XML msgs from MQ source and ignoring invalid messages: Hi there, Did you try not using destructive mode, rather use Removemsg(true
4 June 2009
Informatica Data analyser: Hello Gurus, Can any one tell in data analyser token labeler component can
4 June 2009
RE: Flat File Target [Target_TransControlFile_Dept] FileName Port is not supported with connection or merge option.: Hi Srikanth, It looks like you want to use TC to control when to create new
4 June 2009
RE: Informatica 8.6.1 Hangs: Are you trying to run a workflow and then your system hangs? Have you ever
4 June 2009
RE: how to copy target flat file columns to source definition in informatica: If you have made the mapping from oracle table to flat file, then execute i
4 June 2009
RE: Aggregate and lookup problem ( getting the biggest value): For part 1, sort the data on key1, use an aggregator, use key1 as group by
4 June 2009
RE: Informatica 8.6.1 Hangs: Actually I am facing issue when I click on Run now. Like to say all my conf
4 June 2009
RE: Informatica 8.6.1 Hangs: As mentioned by Rajiv, please elaborate your issue? Have you been able to i
4 June 2009
On DAC: Hi All, I am really facing a problem on DAC past 2 weeks. Like I have insta
4 June 2009
RE: How to load one column of different group to one target but in different columns?: Thanks for the suggestions. I will try using this.
4 June 2009
RE: Aggregate and lookup problem ( getting the biggest value): Hi, Yes, the oracle as well as the timestamp value coming in informatica.
4 June 2009
Re: Aggregate and lookup problem ( getting the biggest value): Hello can i create a port as max(date1) for lookup transformation? I have
4 June 2009
RE: Aggregate and lookup problem ( getting the biggest value): Like Balaji said, did you created a new Output port with Max(Date1) in the
4 June 2009
Re: Aggregate and lookup problem ( getting the biggest value): Do you mean Oracle time stamps? Thanks. Eda Kaya On Thu, Jun 4, 2009 at 12
4 June 2009
Re: Aggregate and lookup problem ( getting the biggest value): Hi, Your query should contain MAX(date1) while grouping in the sql override
4 June 2009
RE: Aggregate and lookup problem ( getting the biggest value): Hi, Check for the timestamps as well associated with the dates, could be th
4 June 2009
Re: Aggregate and lookup problem ( getting the biggest value): The order of the column is exactly as you said. I may written wrong the dat
4 June 2009
RE: Informatica 8.6.1 Hangs: Hi, So far there are not much noise about hanging issues with PC 8.6. If yo
4 June 2009
RE: Aggregate and lookup problem ( getting the biggest value): Hi, Ensure you have the correct date datatype set, as the one you shown in
4 June 2009
RE: Aggregate and lookup problem ( getting the biggest value): What is the order of column in sorter? It should be Key1 first and then Dat
4 June 2009
Aggregate and lookup problem ( getting the biggest value): Hello. I want to ask two questions. Frist. Let's say i have two columns key
4 June 2009
RE: Informatica 8.6.1 Hangs: Can you elaborate more on problem. Are you having any problem while running
4 June 2009
RE: How to concatenate files with delimiter as "|": Do the following if you want to paste files side by side paste -d "|" -f $
4 June 2009
RE: how to copy target flat file columns to source definition in informatica: Hi.. Also copy target file which is created previously onto your local driv
4 June 2009
RE: how to copy target flat file columns to source definition in informatica: Hi... You can create source definition in source analyser and use it in th
4 June 2009
Re: Slowly changing dimension problem: 1. My target has primary key. When I do my first load it is fine. But on my
4 June 2009
RE: Error while fetching the data from SQL server: Hi, Pls. try creating the fresh mapping with the source and also ensure tha
4 June 2009
RE: how to copy target flat file columns to source definition in informatica: Hi, You can reimport your target file sturcture in the source analyzer as s
4 June 2009
RE: how to copy target flat file columns to source definition in informatica: Hi, You can reimport your target file sturcture in the source analyzer as s
4 June 2009
RE: how to copy target flat file columns to source definition in informatica: Hi Anitha, Have you tried to drag target definition to source analyzer? Try
4 June 2009
Re: How to load one column of different group to one target but in different columns?: Hi.. U can use this over ride.. SELECT A.COL3,A.COL4, B.COL4 FROM SAMPLE_TA
4 June 2009
how to copy target flat file columns to source definition in informatica: i had created a flat file columns manually and loaded data from an oracle t
4 June 2009
RE: Informatica Output to a WebPage: Thanks Wang.We've convinced the users that using Infa just for the data exp
4 June 2009
RE: Error while fetching the data from SQL server: Hi Wang, We use 8.6 version of informatica. When I run the query in sql se
4 June 2009
RE: Flat File Target [Target_TransControlFile_Dept] FileName Port is not supported with connection or merge option.: Hi.. Why dont you use CurrentlyProcessedFileName port from the source defin
4 June 2009
RE: sysdate in expression: Awesome Divya. Thanks.
4 June 2009
RE: How to load one column of different group to one target but in different columns?: Hi.. Do the following... Add sorter, sort on col3. Get ports to expression.
4 June 2009
RE: Expression for update and insert: Thanks Divya. It was absolutely what I expected.Thanks again.
4 June 2009
Slowly changing dimension problem: Hi All, I am stuck with this SCD problem. My flow is: SQ-pull all rows EXP1
4 June 2009
Re: Source Qualifier is not reading rows from source table.: check whether at session is there any incremental load query is may b place
3 June 2009
Re: Converting Default Date: create a variable port and save the default date in it.. then check if the
3 June 2009
Re: Date conversion: use the todate function with the specified format.. --balu On Thu, Jun 4, 2
3 June 2009
Flat File Target [Target_TransControlFile_Dept] FileName Port is not supported with connection or merge option.: Hi All I have created a TransactionControl Transformation in INFORMATICA wh
3 June 2009
Informatica Error when Sourcing Too Many Rows: Hello, I have 2 sessions running, each with 1 mapping and I'm getting the
3 June 2009
Date conversion: Hi, Need help with converting field to date. Input is from delimited flat f
3 June 2009
RE: INFORMATICA 7.1.3 - Determination of Packet size and ETL issue: Is this packet size a concept related with SAP BW or same meaning as we kne
3 June 2009
RE: Error while fetching the data from SQL server: Is that SQL run properly at MS sql server? Which version you are using? -wa
3 June 2009
RE: How to load one column of different group to one target but in different columns?: Hi there, Would a normal joiner do the trick? Read same file twice and join
3 June 2009
RE: Converting Default Date: I did the following as you suggested: IIF(TO_CHAR(IN_externalCommentTS) = '
3 June 2009
RE: XML parser : pass through port: I guess i got it documentation was not good enought - needed to go to XML
3 June 2009
RE: Source Qualifier is not reading rows from source table.: Really, without seeing the logs from both runs, it's impossible to determin
3 June 2009
RE: Converting Default Date: Use to_char() to convert your incoming date and compare it against '1-1-190
3 June 2009
How to load one column of different group to one target but in different columns?: Hi All, I have a flat file with the format and values as below(sample) col1
3 June 2009
RE: Cobol variable length record: I haven't looked at COBOL in a looong time... Get out the manual. You are
3 June 2009
Informatica 8.6.1 Hangs: Has anyone had a problem in which Informatica just hangs?
3 June 2009
How can i get PC8.1 Metadata Exchange SDK?: How can i get PC8.1 Metadata Exchange SDK?
3 June 2009
Converting Default Date: To give you a quick overview, my process selects from a database, creates
3 June 2009
Source Qualifier is not reading rows from source table.: I have a problem with the source qualifier. When I run my process for the f
3 June 2009
RE: Informatica 8.1.1 error..... "Cannot create a domain": Hi, Pls. refer to the following thread to resolve your problem. http://data
3 June 2009
RE: Cobol variable length record: Dear Group Members, Any inputs on this...? Regards, ~Harish
3 June 2009
RE: Error while fetching the data from SQL server: Hi Harish, I even tried running in debugger earlier. The records gets filte
3 June 2009
RE: Informatica 8.1.1 error..... "Cannot create a domain": Hi, Pls. refer to the following thread: http://datawarehouse.ittoolbox.com/
3 June 2009
RE: XML parser : pass through port: Does anyone have any idea on this?
3 June 2009
RE: Micro Second Issue in Informatica: Gr8....
3 June 2009
RE: Error while fetching the data from SQL server: Hi, Pls. run the mapping in the debugger mode to find out the problem. Also
3 June 2009
RE: sysdate in expression: SYSDATE is an inbuilt function and you need not define it. Use TO_DATE(TO_C
3 June 2009
RE: Expression for update and insert: Hi Tinks You are saying: 01/21/2100 when the flag is U and N - Can the flag
3 June 2009
Error while fetching the data from SQL server: Hi All, I'm getting the error "RR_4053: Row error occured while fetching da
3 June 2009
Re: Informatica 8.1.1 error..... "Cannot create a domain": Hi , pls chk once u logined as admin of the system or not ,bez when u are c
3 June 2009
RE: Debugger session log: Debugger session logs can be found in session log directory of your server
3 June 2009
RE: Informatica 8.1.1 error..... "Cannot create a domain": It seems like a java issue. Also as harish mentioned, please take care of d
3 June 2009
RE: Enable Test Session questions: Hi When you enable a session for test load, the lookup as well as the mappi
3 June 2009
RE: Enable Test Session questions: Hi, Lookup will work normally. If you enable test load, the basic idea is i
3 June 2009
RE: Enable Test Session questions: Hi, I think that your lookup would get built normally though the test numbe
3 June 2009
RE: Informatica 8.1.1 error..... "Cannot create a domain": Hi, Pls. ensure that you are using the correct database syntax to configure
3 June 2009
RE: Informatica 8.1.1 error..... "Cannot create a domain": Hi, Pls. provide the details about the environment on which you are trying
3 June 2009
RE: Debugger session log: Hi, What version of the PowerCenter you are working with? Debugger is havin
3 June 2009
RE: Informatica 8.1.1 error..... "Cannot create a domain": i am having same issues . tried with the right java version and also checke
3 June 2009
Expression for update and insert: Hi Gurus, I am wondering how to do this : I have a mapping where I have 10
3 June 2009
RE: Informatica 8.1.1 error..... "Cannot create a domain": I am also getting the same error . I have proper version of java on my mac
2 June 2009
RE: decimal number and replace: jbssastry, Thanks your solution worked absolutely great for me. Thanks agai
2 June 2009
Cobol variable length record: I am having a problem geting the correct format on a variable length record
2 June 2009
Debugger session log: Does anyone know how to see find out what was the cause a debug session fai
2 June 2009
Enable Test Session questions: Can anyone tell me in the Session properties when you check ENABLE TEST LOA
2 June 2009
RE: decimal number and replace: Replace comma with period, then TO_DECIMAL() should work. like TO_DECIMAL(
2 June 2009
RE: INFORMATICA 7.1.3 - Determination of Packet size and ETL issue: We had this same issue with 7.1.3 and SAP BW/BI. What we found is that you
2 June 2009
Re: How to concatenate files with delimiter as "|": I don't understand what you are trying to do. Cat will append the files tog
2 June 2009
How to concatenate files with delimiter as "|": Hi i have a problem with the unix shell script right now iam concatenating
2 June 2009
Re: decimal number and replace: *Please try the following. * *lpad*(*substr*(*FIRST*,1, *instr*(*FIRST*,'
2 June 2009
RE: Executing workflow using PMCMD: Hi.. You can run from windows command line. Before that you need to configu
2 June 2009
Re: decimal number and replace: Hi, input variable_1 : REPLACESTR(1,Input,',','.') variable_2 : IIF(SUBSTR(
2 June 2009
RE: normalizer: s....u can see the repositor , folders , the user and permition details als
2 June 2009
RE: Import Stored Procedure: Hi, A Stored procedure transformation will allow to import a package that
2 June 2009
RE: creating receipients: Rajiv is correct. You can use it either way. If you want to use the indivi
2 June 2009
RE: Executing workflow using PMCMD: Hi, For Version 8 you can use the following syntax to run the workflow in b
2 June 2009
Re: what is latest version of informatica: Informatica will be launching version 9 very soon. Divya www.bidw.co.in On
2 June 2009
RE: creating receipients: Distribution list to be created on the exchange server. Same can be include
2 June 2009
RE: sysdate in expression: you can use the inbuilt date function session start time
2 June 2009
RE: decimal number and replace: to_decimal (field,3)...will give me 1.324...like three decimal places after
2 June 2009
RE: sysdate in expression: hi thinkit, how to define SYSDATE...DO you mean input port should be SYSDAT
2 June 2009
RE: decimal number and replace: did you tried making the port data type to decimal?
2 June 2009
RE: sysdate in expression: try this: make sysdate_in port as string datatype in expression and sysdate
2 June 2009
sysdate in expression: how to get default sysdate in mm/dd/yyyy format in expression transformatio
2 June 2009
decimal number and replace: Hi Gurus, I am stuck with this problem.I have a field where values are ,02
2 June 2009
XML parser : pass through port: Hi My source table has one column that holds xml If I simplify the scenario
1 June 2009
RE: what is latest version of informatica: latest version of informatia 8.6.1
1 June 2009
RE: Using xml target in mapping: Hi Ann, It is impossible for Informatica to generate XML target that way. O
1 June 2009
RE: How to detect duplicate row records in Input file in Informatica: Maybe just ordinary thought, put a sorter/aggregator right after the SQ, ha
1 June 2009
RE: How to detect duplicate row records in Input file in Informatica: You could do it with an empty dynamic lookup keyed on rec_body. As you enc
1 June 2009
RE: Problem with Versioning.: Informatica team based environment sometimes behaves really ugly. Take it e
1 June 2009
RE: Informatica 8.6 on window 2003 server enterprise X64: you need to see both server and client installed on 64 bil v or 32 bit v.
1 June 2009
Using xml target in mapping: I am trying to load data from oracle db to xml target. The target has been
1 June 2009
creating receipients: Hi Gurus I have one doubt in e-mail task.In our project we are using this c
1 June 2009
Re: Executing workflow using PMCMD: Yes you can install the workflow using PMCMD even from windows using batch
1 June 2009
Re: Micro Second Issue in Informatica: Hi KKR Good to know that the issue is finally resolved. Cheers Divya www.bi
1 June 2009
RE: Micro Second Issue in Informatica: Hi Harish/Divya, The Issue has been resolved. The issue is with target, the
1 June 2009
Executing workflow using PMCMD: Hi i have installed informatica on windows. Is it possible to execute the w
1 June 2009
RE: Micro Second Issue in Informatica: Harish, As I told, I have set Date Time format MM/DD/YYYY HH24:MI:SS.US, wh
1 June 2009
RE: Micro Second Issue in Informatica: You can also refer to the following to choose the correct settings required
1 June 2009
RE: Micro Second Issue in Informatica: Hi, If this does not helped you, then I think you need to check your sessio
1 June 2009
RE: Micro Second Issue in Informatica: Divya, I have done propogate but no luck once again. In the debugger, the m
1 June 2009
Re: Micro Second Issue in Informatica: It may be a data type issue. May be in some transformation, you have used d
1 June 2009
RE: How to call informatica job from scheduling tools?: I think it's based on the scheduling tool which you are using. If you are u
1 June 2009
Micro Second Issue in Informatica: Hi, One of my source table(oracle) date column having the value 12/23/2008
1 June 2009
RE: Concatenate multiple rows of a column: ur understanding is correct...... Thanks....
1 June 2009
Re: How to call informatica job from scheduling tools?: As mentioned below, create a shell script with pmcmd command with proper sy
1 June 2009
Re: Resilience Timeout: Its true that client resilient timeout is 180 seconds and is not configurab
1 June 2009
Re: Informatica 5.2 and SQL 2005: Generally a session hangs without any errors in log files when there are is
1 June 2009
Re: Informatica 8.6 on window 2003 server enterprise X64: I think you are using the Informatica 32 bit edition. Kindly check and use
1 June 2009
Re: Windows informatica pmcmd from a unix shell script?: It wont be possible for a unix server to communicate with an Informatica se
1 June 2009
Re: Problem with Versioning.: I think the sessions which you have added to the worklets are checked out a
1 June 2009
RE: Windows informatica pmcmd from a unix shell script?: Thanks Brian, This may not be possible. As we have only Informatica windows
1 June 2009
RE: Windows informatica pmcmd from a unix shell script?: One possibility (other than the openSSH suggestion) is to just have the Inf
1 June 2009
RE: Problem with Versioning.: Welcome to the world of Informatica version control. :( :( :( - Brian
1 June 2009
Informatica 8.6 on window 2003 server enterprise X64: Hi All, We are running Informatica 8.6 on window 2003 server enterprise X64
1 June 2009
Re: Windows informatica pmcmd from a unix shell script?: Install cygwin and openSSH on the windows box. Use cygrun to install SSH as
31 May 2009
Re: How to detect duplicate row records in Input file in Informatica: try this, but this is in shell script headercount=`grep "REC_TYPE='H'" inpu
31 May 2009
RE: Windows informatica pmcmd from a unix shell script?: Hi Jaank, Can you please eloborate your answer. Are you saying that, create
31 May 2009
RE: Windows informatica pmcmd from a unix shell script?: write the windows pmcmd and use as batch file, it will work thx Chowhan Fr
30 May 2009
How to detect duplicate row records in Input file in Informatica: Hi experts, I have flat file with header records and each header record sta
30 May 2009
Windows informatica pmcmd from a unix shell script?: Hi All, Informaitca 8.5 is installed on Windows servers. Is it possible to
30 May 2009
Informatica 5.2 and SQL 2005: We are running 5.2 (long story but that is what we have). Last weekend we
29 May 2009
Resilience Timeout: Hello, We have PowerCenter development and production servers in Nashville,
29 May 2009
Re: How to call informatica job from scheduling tools?: You can do a shell script with a line like this: pmcmd startworkflow -sv $
29 May 2009
How to call informatica job from scheduling tools?: Hi All, Could anyone can provide me any input on how can we call informati
29 May 2009
RE: how to stop a particular task (not workflow) when it exceeds a particular time limit: More on the previous post: You can use the "STOPTASK" command to stop the t
29 May 2009
RE: how to stop a particular task (not workflow) when it exceeds a particular time limit: Hi, Yes, you can try using the Timer Task to set the time limit you want to
29 May 2009
how to stop a particular task (not workflow) when it exceeds a particular time limit: Hi All, I am facing following issue with informatica tasks.Actually in my
29 May 2009
RE: related to source qualifier: Thanks for the information,could you please let me know where exactly(any d
29 May 2009
RE: My mapping performance: check the following link for the solution. I just posted it there...for oth
29 May 2009
RE: Error occured during expansion of DB connection parameters: check the link for the solution http://bb.bidw.co.in/viewtopic.php?f=2&t=3
29 May 2009
RE: flatfile processing real time: Hi... Pls see the below script... #!/usr/bin/ksh while [1] do file_10MB=$(f
29 May 2009
RE: Error occured during expansion of DB connection parameters: Thanks a lot . I too faced th problem. There was space after connection st
29 May 2009
RE: Informatica : Flat File to XMLTYPE: Hi, I'm giving you the example. Flat File ---------- NAME,ID,DOB,CNTRY mart
29 May 2009
FEXP error: Hi, I am using fast export connection in informatica and it is giving the f
29 May 2009
Re: Stored procedure calling error in informatica: Authorization issue can happen or seperation check this On Thu, May 28, 200
29 May 2009
RE: Problem with Versioning.: Hi, Pls. ensure that you repeated the exercise for check-out and check-in t
29 May 2009
Re: Execute Vbscript in Informatica: Batch file also recieve parameter while running, so need not to worry about
29 May 2009
RE: Problem with Versioning.: Hi harish thanks for ur replay. Yes the worklet is checked-in properly, the
29 May 2009
RE: Problem with Versioning.: Hi, Does the worklets been checked-in properly afer the changes made to it.
29 May 2009
RE: Perf Tuning: Hi, Have a look on the following link: http://smartdesis.com/2007/informati
29 May 2009
Problem with Versioning.: HI all, we made changes in wrklet, like added some sessions in it. Problem
29 May 2009
RE: Informatica Query for using session email: Hi, Do ensure that the settings are similar in both the environments, while
29 May 2009
Reading XML msgs from MQ source and ignoring invalid messages: I'm on PowerCentre 8.6 and have a workflow to read XML messages from an IBM
28 May 2009
RE: Replace function: Use substr function to remove the first character. SUBSTR(ORG_name,2)
28 May 2009
RE: flat file with two headers: Sorry Bala, mY sincere apologies. I got it working the way u said. I apolog
28 May 2009
Re: related to source qualifier: It can hold only 32771 charaters. The SQL should be split and have a stagin
28 May 2009
RE: flatfile processing real time: If you can make the assumption that any previous files in a list of common
28 May 2009
RE: Informatica Query for using session email: Is your Informatica server on Windows, Unix or Linux?
28 May 2009
Replace function: Hi All, In my mapping I have a column like 'ORG_name'. The value is like :
28 May 2009
RE: My mapping performance: Sukumar, Before testing anything else, change your target to be a flat fi
28 May 2009
RE: My mapping performance: Sukumar, Good job! So you said 10k/sec averagely, but you also said 10min 3
28 May 2009
Informatica Query for using session email: I am using failure email option, in session to send email to the email addr
28 May 2009
Re: Oracle temp tablespace error while loading data to the target: Hi Wilson Wang. That's the answer i was looking for. Thanks a lot. I will t
28 May 2009
RE: Oracle temp tablespace error while loading data to the target: Hi edakaya, Your guess is right, the reader continuous reading from the sou
28 May 2009
RE: My mapping performance: Hi Wang, Thanks for your reply. Regarding your suggestion : 1. "Did you hav
28 May 2009
RE: related to source qualifier: It is true. I tested in my tools, v8.1.1 sp2. It seems only allow 32k in to
28 May 2009
RE: [informatica-l]Operand cannot be converted to a number: I get the same error if i try to validate the following expression: trunc(
28 May 2009
RE: Informatica : Flat File to XMLTYPE: Are you saying each line of flat file will be converted into a row into tar
28 May 2009
RE: Execute Vbscript in Informatica: From the document, you can find: You can use the following parameters and v
28 May 2009
RE: My mapping performance: You provided so detailed information! Did you have any test on throughput a
28 May 2009
RE: Concatenate multiple rows of a column: My understanding is as follows A B C D E F G_S H65 P 1/12/2010 V L 1
28 May 2009
Perf Tuning: Does anyone have some documentation on Perf Tuning besides the PDFs that In
28 May 2009
RE: INFA on UNIX to MS Access/Excel: Sorry for late reply, I posted in another thread also. There are open sourc
28 May 2009
RE: INFA on UNIX , MS Access as Source: This will not work Soma, Unix does not have the drivers for MSACCESS. If yo
28 May 2009
RE: flatfile processing real time: Hi AR, Assuming that you will have all these files in a specified directory
28 May 2009
My mapping performance: Hi, I have a mapping that loads about 2 million rows from a tab delimited
28 May 2009
Stored procedure calling error in informatica: I have informatica unconnected stored procedure transformation which calls
28 May 2009
Execute Vbscript in Informatica: Hi is it possible to execute a VBScript in as a pre-Sessin Command Task in
28 May 2009
Informatica : Flat File to XMLTYPE: Hi, My requirement is to load a oracle table from a flat file. The fla
28 May 2009
RE: related to source qualifier: instead you can place all you queries in a stored proc and invoke the SP fr
28 May 2009
RE: flat file with two headers: Hi, Check the expression in the output port, you would have add time in the
28 May 2009
Re: Concatenate multiple rows of a column: Hi Vizzy Please post your query more clearly. You can use tabular format or
28 May 2009
Re: flat file with two headers: Hi Tinks Bala has given a very clean way of doing it and it should work fin
28 May 2009
RE: flatfile processing real time: Hi.. Write a file watcher script and keep on checking byte size of the file
28 May 2009
RE: Informatica 6.x Batch Processing: Hi.. Instead of 30 independent workflows, create multiple worklets and incl
28 May 2009
flatfile processing real time: Hi all. i have a scenario where i have to download files in realtime throug
28 May 2009
RE: flat file with two headers: hey bala i am getting this day x1|y1 day x2|y2 day x3|y3 night x5|y5 night
27 May 2009
RE: flat file with two headers: day x1|y1 day x2|y2 day x3|y3 day x4|y4 night x5|y5 night x6|y6 night x7|y7
27 May 2009
Informatica 6.x Batch Processing: I would like to know in Informatica version 6.x , if I want to run a batch
27 May 2009
RE: SQL Server Informatica Connection Issue: Hey Everyone, Everything works fine! Thanks to all .. and specially to Hari
27 May 2009
RE: TM_6795 error message while running workflow. Please advise.: For me helpped - If You change mapping of session, You should Validate it i
27 May 2009
RE: Issue with AS400 table: were you able to find the answer..? -----Original Message----- AS400 tables
27 May 2009
RE: Informatica Two Digit Year Comparisons: I found the solution. Thank you to those already considering my question.
27 May 2009
RE: Oracle temp tablespace error while loading data to the target: Its not a problem in the SQL Override at all, otherwise the Data Would not
27 May 2009
RE: RE:Informatica Two Digit Year Comparisons: Thank you. I did find that solution. Robert E. Martin | Applications Devel
27 May 2009
RE: Informatica Two Digit Year Comparisons: You need to use RR instead of YY, as in RRMMDD. Informatica treats 0-49 a
27 May 2009
RE: SQL Server Informatica Connection Issue: Harish, Thanks Harish for the reply! Are you suggesting that informatica do
27 May 2009
Informatica Two Digit Year Comparisons: I have as of yet, been unable to find good informaiton on how Informatica
27 May 2009
RE: flat file with two headers: Hi Tinks, Here is one more solution to acheive your requirement..... 1) SQ-
27 May 2009
RE: Concatenate multiple rows of a column in Informatica/by using Oracle SQL Query: Hi... Can you give some other data example. Output is bit confusing. /Rajiv
27 May 2009
Re: Concatenate multiple rows of a column in Informatica/by using Oracle SQL Query: Hi Vizzy. Do you know the max number of lines you have for diferents A colu
27 May 2009
RE: flat file with two headers: Hi.. If you want to go with normalizer then it should have fixed occurances
27 May 2009
RE: Mapping variables not propagated: Thanx for reply i will try that way, the thing is, that mapping have output
27 May 2009
RE: Problem with SQL override: This is why I preach to people to avoid using SQL overrides if you don't ne
27 May 2009
RE: flat file with two headers: While a normalizer could be used in this situation (it's pretty easy to und
27 May 2009
RE: flat file with two headers: Hi Rajiv, Thanks for your explanation. Can you plz suggest how to go about
27 May 2009
RE: Concatenate multiple rows of a column: I have already posted it clearly,could someone put some light over here,so
27 May 2009
RE: Mapping variables not propagated: Hi, It seems that your variable is reading the value from the Repository af
27 May 2009
RE: flat file with two headers: Hi, Follow below Steps :- 1. Add Source Qualifier 2. Add Expression1 to com
27 May 2009
Mapping variables not propagated: HI all Ok here is my problem, my mapping have 2 variables, name and value.
27 May 2009
Mapping variables not propagated: Ok here is my problem, my mapping have 2 variables, name and value. in work
27 May 2009
RE: flat file with two headers: My requirement is rather than using a source qualifier I have to use a norm
27 May 2009
RE: LTRIM, RTRIM: Hi. First check the length of the column if it is greater than zero then go
27 May 2009
Re: Problem with SQL override: The order of ports in the Source Qualifier should be similar to the columns
27 May 2009
Re: related to source qualifier: I agree with Brian. A sql query of 1000 lines should be broken down into pi
27 May 2009
RE: flat file with two headers: Take Only one output port and use this query at Source Qualifier select ca
27 May 2009
RE: Problem with SQL override: that was my problem too... Override SQL should have same columns as in Sour
27 May 2009
Re: Oracle temp tablespace error while loading data to the target: Thank you very much for the reply. I checked the tablespaces but they were
27 May 2009
Re: Oracle temp tablespace error while loading data to the target: Thanks for the replies. I do appreciate. yes i can understand that if i sea
27 May 2009
RE: Getting error while using DB2 External Loader to load the table: you can visit www.bidw.co.in. they are experts in Informatica. you should h
27 May 2009
RE: Getting error while using DB2 External Loader to load the table: Hi, I am still waiting for the response. Is any buddy who worked on DB2 Ext
27 May 2009
Concatenate multiple rows of a column in Informatica/by using Oracle SQL Query: Hi All, My source table data is as below: A B C D E F
27 May 2009
Re: flat file with two headers: please give some wrk around how we can get day & night columns in file with
27 May 2009
RE: Unable to start service (Dev_Rep) on any node specified for the service: You can do from the Workflow Manager. Do the following: Do the login to you
27 May 2009
RE: Informatica 8.5.1 Admin console problem: Did you try a simple uninstall and reinstall to ensure that all is in place
27 May 2009
RE: SQL Server Informatica Connection Issue: Hi, Pls. ensure that you are using the correct syntax while connecting to t
27 May 2009
RE: Move repository from 8.1 to 8.6: Hi, Pls. check the following link to get the related information on the sam
27 May 2009
RE: flat file with two headers: Hi, Can you elaborate as to how to use a normalizer plz? Thanks VK
26 May 2009
RE: LTRIM, RTRIM: It could be source data issue. Did you check the source data not to be null
26 May 2009
RE: flat file with two headers: Use to data flows. In the first flow filter rows where time = 'day' and lo
26 May 2009
flat file with two headers: Hi gurus, A quick question. I have a relational source Name|Address|time
26 May 2009
RE: Extract data of Essbase with Informatica Power Center 8: You will need to have the PowerExchange for Hyperion Essbase Installation P
26 May 2009
RE: How to move Folders from 7.1.4 to 8.1.1: Can you let me know the name of the informatica's document and the page num
26 May 2009
RE: How to move Folders from 7.1.4 to 8.1.1: When you say "upgrade" the repository, u mean to say copy the 7.1.4 repos t
26 May 2009
Move repository from 8.1 to 8.6: Hi all, We have an instance of 8.6.1 running. We also have 8.1
26 May 2009
SQL Server Informatica Connection Issue: Hi Everyone, I am trying to connect to SQL server using a user called 'info
26 May 2009
RE: LTRIM, RTRIM: Even if i don't use ltrim, rtrim..it is loading null. I tried to load as is
26 May 2009