how to get flatfile containg 10 records half records one
target another half another target
Answer Posted / mahipal reddy
first create a sequence to those 10 records n using filter
or router transformation filter first 5 columns n load into
target similarly remianing 5 records.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Is it possible to create multiple domains on a single Informatica server?
What are the new features of informatica 9.x at the developer level?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
how we can load rejected record's at run time?(not through bad files)
What is an active transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the differences between source qualifier and joiner transformation?
How can we create index after completion of load process?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How many types of sessions are there in informatica.please explain them?
Enlist the tasks for which source qualifier transformation is used.
What are the informatica performance improvement tips