Interested to Buy Any Domain ? << Click Here >> for more details...
What is souce qualifier transformation it is active or
passive
- 2 Answers
- 10555 Views
- HCL, I also Faced
- E-Mail Answers
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 |
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
how to load only the first and last record of a flat file into the target?
What is the default source option for update stratgey transformation?
Explain the scenario which compels informatica server to reject files?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
without table how to come first record only in oracle?
What is informatica etl tool?
When to use normalization transformation other than cobol source?
After we make a folder shared can it be reversed?Why?
Explain Dataware house architecture .how data flow from intial to end?
What is sequence generator transformation in informatica?
Is it possible to revert a global repository to local one and why?
Teradata 
