Answer Posted / ajit
HLD is the over all overview design of the system whereas
LLD is the not over all design,it is a detailed design of
the each part of the system.
HLD is always done before the LLD.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is a shortcut and copy in Informatica and how two are different with each other?
Explain sessions. Explain how batches are used to combine executions?
Define mapplet?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
server hot-ws270 is connect to Repository B. What does it mean?
What are the different ways to implement parallel processing in informatica?
Explain the aggregator transformation?
What are different types of transformations available in informatica?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What is a surrogate key?
Explain load alternative records / rows into multiple targets - informatica
Explain the different dimensions.
What is decode in static cache?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?