Interested to Buy Any Domain ? << Click Here >> for more details...
how to load the data in fact table..
using look up transformation how to view the second record.
usally look up shows matching record for only one value. if
i have same value its not displaying.
ex: problem i faced.
i have total, student no and name in table student
i used aggregation transformation to display max(total). i
have two same max values in total. when i look up the
student name and no for this max(total), its showing only
one name and no, its leaving the second one. how to rectify
it. plz tel me step by step or clearly.
- 1 Answers
- 4368 Views
- I also Faced
- E-Mail Answers
Answer / preety
While creating lookup transformation , make the lookup as active. you will get all the matching records from the lookup table.
| Is This Answer Correct ? | 0 Yes | 0 No |
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
Separate from a database, an information bazaar, and an information stockroom?
What are the diffrences between joiner transformation and source qualifier transformation?
Explain lookup transformation in informatica
What is a joiner transformation?
wht is cdc?how to use it in creation of mappings?
What do you understand by a term domain?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What's the layout of parameter file (what does a parameter file contain?)?
what is the drillup & drill down?and use of the drill up and drill down?
what are the output files that the informatica server creats during running a session?
Teradata 
