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
What is a command that used to run a batch?
what is the use of Java Transformation in Informatica 8.x?
What are the types of presistent cache in look up tr.
What is the different lookup cache(s)?
Can you start a session inside a batch individually?
What is status code?
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
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
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
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?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?