Can we parametrize the values of IN statement.
Ex.
Inside parameter file:
Parameter='A','B','C'
Inside Code:
IN (INPUT_CHARACTER, $$Parameter)
- 2 Answers
- 5022 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / pondara shivaji
Prankly asking have u got selected interview by answering
above question.
| Is This Answer Correct ? | 1 Yes | 0 No |
how does the server recongnise the source and target databases.Elaborate on this
Define slowly changing dimensions (SCD)?
where we cannot use sorter Transformation. if we use then we will not get correct data?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
how do u implement configuration management in Informatica?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
What are the modules in Power Mart?
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
What is etl tool in hadoop?
What is tracing level?
What is etl process?
Teradata 
