I Have 100 Records in a relational tble and i want to load
the record in 3 targets , first records goes to target 1
and second to target 2 and third to target 3 and so
on ,what are the tx used in this and what are the
logics ,can any one help me ?? Thanks in Advance

Answer Posted / im

Using Constraint Based Loading option in SQ T/r......

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What will be the approach?

566


What is a sequence generator transformation?

563


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1628


How can we store previous session logs?

552


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1318






Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

619


what are 3 tech challenges/ common issues you face?

1873


Explain lookup transformation is active in informatica

650


What is meant by a domain?

611


Define mapping and session?

577


What is a router transformation?

613


without table how to come first record only in oracle?

1835


Which development components of informatica have the highest usage?

580


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1457


What are the main features of Oracle 8i with context to datawarehouse?

1668