Can we parametrize the values of IN statement.
Ex.
Inside parameter file:
Parameter='A','B','C'
Inside Code:
IN (INPUT_CHARACTER, $$Parameter)
Answer Posted / 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 |
Post New Answer View All Answers
what are the reporting tools and difference between them?
Explain about hash partitioning?
Do we need an ETL tool? When do we go for the tools in the market?
what is dynamic insert?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Explain about etl data integration software?
what is the difference steps for data modeling?
Can u access a repository created in previous version of Informatica?
What is tracing level? How many types of transformations supported by sorted input?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what is the difference between cardinality and Nullability?
How many types of transformations supported by sorted input?
What are the etl testing operations includes?
List few etl bugs?