What are limitations of joiner transformation?
Answers were Sorted based on User's Feedback
Answer / seshagiri k
1.Both the pipelines begin with the same original data spouece
2.Both input pipelines originate from the SQ transformation
3.Both input pipelines originate from the same normalizer t/r
4.Either input pipelines contains an update transformation
5.Either input pipelines contains a connected or unconnected
sequence generator transformation
| Is This Answer Correct ? | 14 Yes | 5 No |
Answer / maruthi
JOINER,AS IT JOINS DATA FROM HETROGENOUS SOURCES
1)STRUCTURE OF THE BOTH TABLES SHOULD BE SAME.(V.IMP)
ANYWHERE SAY IT FIRST
| Is This Answer Correct ? | 2 Yes | 34 No |
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
Can we update the data in flat file using update strategy?
daily how much amount of data send to production?
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.
How can one identify whether mapping is correct or not without connecting session?
Explain what is informatica metadata and where is it stored?
How to call shell scripts from informatica?
What is the advantage of informatica?
What is hash partition?
How can we integrate different flat file data in a single mapping and with in a single execution
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
What is the reusable transformation?