Can we parametrize the values of IN statement.
Ex.
Inside parameter file:
Parameter='A','B','C'
Inside Code:
IN (INPUT_CHARACTER, $$Parameter)
Answers were Sorted based on User's Feedback
Answer / tabish khan
Frankly i dont know the answer but i told the interviewer that
we cannot do this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pondara shivaji
Prankly asking have u got selected interview by answering
above question.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is granularity? Please explain with example
can be used COM component in Informatica ?
What is the main difference between peek stage and copy stage
what is the difference between OLTP database and data warehousing database?
what is the use of structures?how many nodes can u create in a structure?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
flat filevalidation in informatica
Eliminating of duplicate records without using dynamic lookups
Explain about etl data integration software?
What do you understand by the term ‘transformation’?
What are the different Lookup methods used in Informatica?