There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
difference between informatica 8.1.1 and 8.6
Under which circumstances, informatica server creates reject files?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Enlist few areas or real-time situations where informatica is required.
what is the flow?
What is Session and Batches?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?