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 is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
Explian the connected and unconnected lookup transformation
where does the default group roew in a router is stored what is the default size of memory in router
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
When do you use mapping parameters? (In which transformations)
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
what is diff between grep and find
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
What are the Advantages of de normalized data?
Can we insert and update a target table without using update strategy transformation?How?
What is parameter file?