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 |
What happens when a session fails and you click on recover?
write a query to retrieve the latest records from the table sorted by version(scd)
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is informatica metadata?
How to delete the (flat file) data in the target table after loaded.
How to enter same record twice in the target table,explain?
How can you access the remote source into your session?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.