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 are the different Reporting and ETL tools available in the market?
What is virtual Data Warehousing?
What is fact? What are the types of facts?
What is ROWID explain ?
What do you understand by the term ‘transformation’?
Identifying the bottlenecks in various components of Informatica and resolving them.
how to load the data to fact table?
Difference between flat files and relational sources?
How we can see table structure?
Compare etl & elt?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?