what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
2 6817Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
1364Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
1406hoe to access second value in mapping parameter if it is having more than one value ?????????????
1138Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
2576can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
1318Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
1155
What are the modules in Power Mart?
what is data modeling?
What are various etl tools in the market?
if i have a query as flat file how can we load data to target table
Hi 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.
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
dimension object created in oracle can be imported in designer?how?
what are the session parameters? How do u set them?
what is the difference steps for data modeling?
What is data cleaning?
Explain and compare etl & manual development?
SCD2 will work on only dimension tables as well as fact Table?
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
What are materialized views & where do we use them?
how would u estimate the size of Aggregator transform data and index cache?