Interested to Buy Any Domain ? << Click Here >> for more details...
Can we parametrize the values of IN statement.
Ex.
Inside parameter file:
Parameter='A','B','C'
Inside Code:
IN (INPUT_CHARACTER, $$Parameter)
- 2 Answers
- 6226 Views
- Cognizant, IBM, I also Faced
- E-Mail Answers
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 is session partitioning?
How can we use external procedural logic in informatica?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
How to fine tune mappings?
what is pmrep command?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What are the different etl testing categories as per their function?
can be used COM component in Informatica ?
Explain what is etl process? How many steps etl contains explain with example?
tell me few points when u become TL
dimension object created in oracle can be imported in designer?how?
what happens if the info.server doesn't find the session parameter in the parameter file?
what are the concerns of OLTP and DSS systems?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What is full load & incremental or refresh load?
