Interested to Buy Any Domain ? << Click Here >> for more details...
what are the limitations of pushdown optimization
technique ?
Advance thanks
- 3 Answers
- 41375 Views
- Puma, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nitin
1) we can not perform PDO if we are using variable ports and informatica inbuilt functions.
2) If we have source and target on the different schema we can not go for full PDO, in this case either we have to go for source PDO or Target PDO.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / rao
1)We can not apply push down optimization if mapping contain
aggregate transofrmation.
2)When we implement p.optimization ,the integration services
send logic to databases.because of this wa can not capture the
rejected records in reject file.
| Is This Answer Correct ? | 7 Yes | 14 No |
Answer / chandu
we can't implement for aggregator tranformation
we cant implement for master source in joiner transformation
| Is This Answer Correct ? | 7 Yes | 18 No |
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
what is incremental data aggregation?
How to differentiate between the active and passive transformations?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is pmcmd command?
which one is better performance wise joiner or look up
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What is Java Transformation? what are the uses of it?
how to remove staging area
What if the source is a flat-file?
Teradata 
