What the difference is between a database, a data warehouse and a data mart?


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

Post New Answer

More Informatica Interview Questions

What is a command that used to run a batch?

2 Answers  


what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,


What are the types of presistent cache in look up tr.

0 Answers   IBM,


What is the different lookup cache(s)?

0 Answers  


Can you start a session inside a batch individually?

2 Answers  






What is status code?

2 Answers  


I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  


i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,


write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,


we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  


How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,


what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  


Categories