Interested to Buy Any Domain ? << Click Here >> for more details...
what is the process we used in joiner transformation,there
is no matching column in sources?
- 2 Answers
- 6945 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / emmanuel
Create a dummy port in both the sq transforamtion and join
based on the dummy values
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / anithaks
I think we can use Union Transformation in such case!!
| Is This Answer Correct ? | 0 Yes | 8 No |
Write the prerequisite tasks to achieve the session partition?
Can we override a native sql query within informatica?
Is there any way to read the ms excel datas directly into informatica?
How i can upload the MainFrame source For Informatica ?
What is diff joiner and lookup
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
What are the measure objects?
What are multi-group transformations?
How to use procedural logic inside infromatica?
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
how to duplicates from expression transformation without using sorter before that
Teradata 
