in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1721

How many number of sessions can one group in batches?

682

Explain what is informatica metadata and where is it stored?

599

What are the mapping parameters and mapping variables?

612

How you can differentiate between connected lookup and unconnected lookup?

598

What is the need for an etl tool?

625

Does an informatica transformation support only aggregate expressions?

598

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1822

What is the use of code page?

591

What are the types of schemas we have in data warehouse.

518

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6446

How do you migrate data from one environment to another?

633

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7658

Explain lookup transformation is active in informatica

650

expain about the tune parameters?

1868