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 initial load and what is full load?

1 Answers  


when should one create lookup transformation ?

2 Answers  


what are the parts of Informatica server ?

1 Answers   GE,


what is the meant by Normalization and de-normalization?

2 Answers  


Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

320 Answers   Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,


What is etl process? How many steps etl contains?

1 Answers  


What exact we can see in table?

1 Answers  


what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?

1 Answers  


Mention few test cases and explain them?

1 Answers  


what are the reporting tools and difference between them?

1 Answers  


what make u disappointmnets in u r career

1 Answers   Infosys,


when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

1 Answers  


Categories