LOOKUP Condition is nothing but a Join condition?
What type of join condition it,by default ?
Using the LookUP Condition How many types of relational
conditions we can make ?
Answer Posted / venkat
here lkp transformation is perform left outer join only.
it will display matching and non matching records,but in
case of non matching(while using conn lkp)records return
default value.while using unconn lkp returns null value.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Different circumstance which drives informatica server to expel records?
What is the difference between Active and Passive transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the advantages of informatica?
How can we use batches?
Where do we use mapping variables in informatica?
Define joiner transformation?
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?
Write the prerequisite tasks to achieve the session partition?
What does role playing dimension mean?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
what are factless facts? And in which scenario will you use such kinds of fact tables.