how to do aggregation (year wise quantity ) using only
source qualifier, the source is sql server date as datetime
data type and
target as flat file with year (string datatype)


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

how do u set partition points in the mapping?

0 Answers  


Can u access a repository created in previous version of Informatica?

0 Answers  


what is different between sequential batch and concurrent batch and which is recommended and why?

0 Answers  


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

0 Answers  


what is meant by drill through?(Mascot)

1 Answers  


how do u automate Extraction process?

1 Answers  


what is granularity in Data ware House?

0 Answers   IBM,


when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers  


What is a staging area? What is the purpose of a staging area?

0 Answers  


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

0 Answers   Accenture,


Define Dynamic push down optmization?

0 Answers   HP,


Explain about the data integration suite features?

0 Answers  


Categories