What is a diff between joiner and lookup transformation
- 16 Answers
- 92872 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / kalpana
joiner doesnt support nonequi joins where as lookup support
nonequijoin
| Is This Answer Correct ? | 72 Yes | 12 No |
Post New Answer View All Answers
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?
What are pre and post-session shell commands?
what is unit testing?tell me proceedure
What is Data Caches size?
What is the sequence generator transformation in informatica?
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
What could be the possible resons of locks by user?
What are the differences between oltp and olap?
How to partition the Session?
Partition, what happens if the specified key range is shorter and longer
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 .
How do we call shell scripts from informatica?
What is the difference between informatics 7x and 8x and what is latest version?
How can you increase the performance in joiner transformation?
what is the size of u r source(like file or table)?
