what is the process we used in joiner transformation,there
is no matching column in sources?
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 |
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
Whatis the difference between View and Materialized View ?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
if i am having 10 records in source, i want 20 records in target...how will you do it
Whats there in global repository
explan ur project architecture?
In a sequential batch can u run the session if previous session fails?
What is main use of mapplet?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Differentiate between source qualifier and filter transformation?
What is a sorter transformation?
How can you define a transformation? What are different types of transformations in Informatica?