Interested to Buy Any Domain ? << Click Here >> for more details...
how to design mapping half of source table records into one
target and remaining half into another target
- 8 Answers
- 15281 Views
- ABC, I also Faced
- E-Mail Answers
Answer Posted / sbvp
hi raj
when we use source as a flat file
if a flat file contians 10 records assume ok
take seq gen t/r- next val
to exp t/r
in that add a new port and give seq gen-nextval to that new
port(suppose call as seq_num ok)
take RTR t/r
create two out ports ok
seq_num<=5
seq_num>=5
contect to two tgrts ok
thanks
sbvp
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is DR strategy for Informatica project?
Explian the Process of deployment groups in informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is a rank transform?
Describe an informatica powercenter?
What is the use of code page?
How to load a Dimension ? and how to load a fact table?
can u give example for factless fact table
what is index?how it can work in informatica
What are the types of data warehouses?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
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?
explain about unit testing? in real time?
Explain the different kinds of facts.
What do you understand by term role-playing dimension?
