How/where can i install Informatica software with oracle or
teradata as database
- 0 Answers
- 2192 Views
- I also Faced
- E-Mail Answers
If u r using dynamic cache lookup port will be thier in thet which option u will select
What is a unit Testing?
What is the difference between informatica 7.0 and 8.0?
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
What is an expression transformation in informatica?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
As union transformation gives UNION ALL output, how you will get the UNION output?
guys which is the best institute in banglore to learn informatica??
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
How to recover sessions in concurrent batches?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Teradata 
