if i have a query as flat file how can we load data to target table

1396

When do we go for the tools in the market?

943

What is tracing level? How many types of transformations supported by sorted input?

966

how do u identify the changed records in operational data?

2524

what is an ETL or ETT? And what are the different types?

7493

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1071

Explain about hash partitioning?

992

What are cubes and olap cubes?

980

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2269

flat filevalidation in informatica

2148

what is the difference between cardinality and Nullability?

3440

Compare ETL & Manual development?

941

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?

931

What is a mapping, session, worklet, workflow, mapplet?

979

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?

1854