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

How to know informatica conslole password??

0 Answers  


what is Forward,Reverse and Re_engineering?

0 Answers  


What are the steps involved in etl process?

0 Answers  


what is the advantage of persistent cache? when it should be used?

2 Answers  


How to fine tune mappings?

0 Answers  






what do u do when DB time takes more?in sap bi

0 Answers  


Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

0 Answers  


how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers  


explain the methodology of Data Warehousing?(Polaries)

0 Answers  


What is the difference between Data Warehousing and Data Mining?

0 Answers  


what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers  


Difference between flat files and relational sources?

0 Answers  






Categories