What is souce qualifier transformation it is active or
passive
Answers were Sorted based on User's Feedback
Answer / smarati
It is active transformation because,
- we can do sql override
- select distinct option, which reduces the number of rows.
- we can use join condition
All the above increases/decreases the number of rows, so SQ
is active.
Thanks
Som
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / sushma
SQ transofrmation reads the rows from the source. It is an
active transformation.
| Is This Answer Correct ? | 4 Yes | 1 No |
what is shortcut in informatica? difference between shortcut,reusable object?
What is the benefit of session partitioning?
What are the main issues while working with flat files as source and as targets ?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
What is different between the data warehouse and data mart?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
What are the different ways to implement parallel processing in informatica?