Explain the use of aggregator cache file?
No Answer is Posted For this Question
Be the First to Post Answer
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How many ways a relational source definition can be updated and what are they?
What is the use of target designer?
Name the different lookup cache(s)?
Can we get 1st record through Informatica(without sequence number).
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?
Why we use stored procedure transformation?
What are the options in the target session of update strategy transsformatioin?
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping