How your source files are coming to your ETL server.
Actually at which stage of your mapping it is happen.
Answer / srini
Flat Filies are coming through Connect Direct in ETL Server.
Is This Answer Correct ? | 2 Yes | 0 No |
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
Differentiate between joiner and lookup transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
what is scd?
what is bridge tables in informatica
How to run a session, which contains mapplet?
What are the mapping paramaters and mapping variables?
What is the procedure to load the fact table.Give in detail?