How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
2 4652Hi 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.
1722my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
HCL,
1 3613how 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)
2243Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
2 5037explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
3622
what are the data modeling tools you have used?(polaris)
what is session partitioning?
Explain etl mapping sheets?
What is etl process?
Which transformation we use to convert 'NA' to 'Not Available'
What is a materialized view log?
What is the difference between project backlog and product backlog?
what is the difference between cubes and package in cognos
What are dimensions?
Explain what is etl process? How many steps etl contains explain with example?
What are the different Lookup methods used in Informatica?
What is virtual Data Warehousing?
what is dynamic insert?
What is partitioning? Explain about round-robin, hash partitioning.
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?