Can we parametrize the values of IN statement.
Ex.
Inside parameter file:
Parameter='A','B','C'
Inside Code:
IN (INPUT_CHARACTER, $$Parameter)
Answer Posted / pondara shivaji
Prankly asking have u got selected interview by answering
above question.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
In Which Transformation We Can Use Having Clause In Informatica?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
Explain about hash partitioning?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What do you understand by active and passive transformations?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
What is tracing level and what are the types?
what is Forward,Reverse and Re_engineering?
What are the different Lookup methods used in Informatica?
What is abap? What are idocs?
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.?
how do use session mapping parameters ?(in which transformation)
Explain do we need an etl tool? When do we go for the tools in the market?