Interested to Buy Any Domain ? << Click Here >> for more details...
if soource is having 10 records how will u insert 20
records to target
- 6 Answers
- 12518 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / priyank
Take 2 instances of source and join them unsin UNION
transformation(provided the target structure is same as the
source structure).
SQ1 --> UNION --> EXP --> Target
SQ2
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can we change Dynamic to Static or Persistent cache? If so what happens?
How can we delete duplicate rows from flat files?
what is the size of your data warehousing?
What is meant by active and passive transformation?
How to extract sap data using informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
can we override a native sql query within informatica? How do we do it?
How to load last n records of file into target table - informatica
What are multi-group transformations?
Can we create a node as a gateway node and the same node can be assigned to a grid?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
list out all the transformations which use cache?
Can we create multiple integration service on single repository?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
