Interested to Buy Any Domain ? << Click Here >> for more details...
I have worked on Informatica 7.1.1. I want to know the
answer for the below question.
Target is not created initially.Then how to take the DDL
script from the source and run the Mapping by creating the
Target dynamically?Is it possible by SQL Transformation?
- 0 Answers
- 1886 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
What are active transformations.
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
Why we use ENABLE HIGH PRECISION in session properties?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
On which transformations you created partitions in your project?
What is the difference Between Mapping parameter and variable
what is threshold error in informatica?
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
What is workflow? What are the components of the workflow manager?
What is the sql query overwrite in source qualifier in informatica
Teradata 
