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

what is meant by drill through?(Mascot)

1 Answers  


What is abap? What are idocs?

0 Answers  


how would u estimate the size of Lookup transform data and index cache?

0 Answers  


Which type or t/s is used to convert rows into column & column into rows

9 Answers   Infosys,


Explain what are the various etl tools in the market?

0 Answers  






what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.

2 Answers   IBM, Tech Mahindra,


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

0 Answers  


What are the different ways to deploy the code in informatica?

1 Answers   IBM, Saama Tech, Wipro,


how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com

2 Answers   TCS,


How to know informatica conslole password??

0 Answers  


we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??

4 Answers  


what is data modeling?

0 Answers  


Categories