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



Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A'..

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

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A'..

Answer / pondara shivaji

Prankly asking have u got selected interview by answering
above question.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More ETL Interview Questions

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

0 Answers  


When do we analyze the tables?

0 Answers  


how do u really know that paging to disk is happening while u are using a lookup transform?

0 Answers  


Identifying the bottlenecks in various components of Informatica and resolving them.

2 Answers  


how do u extract data from different data sources explain with an example?

0 Answers  






list and discuss two approaches for updation of target table in Informatica and how they are different.

0 Answers  


what is HISTOGRAM? how to generate statistics?

1 Answers  


how do u implement unconn.stored proc. in a mapping?

1 Answers  


Can we create Hierarchies in generic datasources?

0 Answers   CTS,


What is the main difference between peek stage and copy stage

2 Answers  


what are the different forms of normalization?

2 Answers  


can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

0 Answers   Cap Gemini,






Categories