How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example)
Answer / sarvesh
by using the sql override option in the edit properties in
s.q transformation,
| Is This Answer Correct ? | 2 Yes | 2 No |
what is session partitioning?
what are the facilities provided by data warehouse to analytical users?
if i have a query as flat file how can we load data to target table
how do u decide whether u need to do aggregations at database level or at Informatica level?
What are three tier systems in etl?
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
Explain about round-robi?
What is the difference between project backlog and product backlog?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is session partitioning?
What are snapshots?