How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
2 5727Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
2212my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
HCL,
1 4331how 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)
2696Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
2 6208explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
4112
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What is a staging area? What is the purpose of a staging area?
Explain etl mapping sheets?
what is dynamic insert?
How many steps etl contains explain with example?
Give the benefits of data integration suite?
How many steps etl contains?
what is granularity in Data ware House?
what is pmrep command?
how do u handle performance issues in Informatica . where can u monitor the performance ?
Two default user groups created in the repository are____and_____.
hoe to access second value in mapping parameter if it is having more than one value ?????????????
can cubes contain measures ?
Define Dynamic push down optmization?
what is an ETL or ETT? And what are the different types?