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
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 do u implement scheduling in Informatica?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
where we cannot use sorter Transformation. if we use then we will not get correct data?
Define slowly changing dimensions (SCD)?
What is etl tool in hadoop?
how do u really know that paging to disk is happening while u are using a lookup transform?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
list and discuss two approaches for updation of target table in Informatica and how they are different.
how do use session mapping parameters ?(in which transformation)
What are cubes and olap cubes?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.