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
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 is etl tool in hadoop?
what is pmrep command?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
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 are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
how do u really know that paging to disk is happening while u are using a lookup transform?
Explain different types of partitioning?
What is etl process? How many steps etl contains?
how to connect to a flatfile through ftp in informatica
dimension object created in oracle can be imported in designer?how?
Is hadoop a etl tool?
What is meant by incremental load?
how do u implement configuration management in Informatica?