How can we update a record in the target table without using update strategy?
- 0 Answers
- 924 Views
- I also Faced
- E-Mail Answers
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
What are multi-group transformations?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the tuning techniques you applied during your last project
Explain why we use partitioning the session in informatica?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
what are cost based and rule based approaches and what is the difference?
What the difference is between a database, a data warehouse and a data mart?
How to generate sequence numbers using expression transformation?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
Teradata 
