How to jion 2 tables, without using any condition?
Answer Posted / raj
Add dummy column in expression or Source Qul. for both
source and use that column in join condition.
Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
How can you validate all mappings in the repository simultaneously?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
where to store informatica rejected data?
What is enterprise data warehousing?
How to generate sequence numbers without using the sequence generator transformation?
Explain transaction control transformation in informatica
How to extract sap data using informatica?
What is the benefit of session partitioning?
Write the unconnected lookup syntax and how to return more than one column.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is domain in terms of informatica?
What are the differences between a connected lookup and unconnected lookup?
Partition, what happens if the specified key range is shorter and longer
How can repository reports be accessed without sql or other transformations?