how many data models u have done in informatica project?
Answer Posted / prabhu
As an informatica developer you will not mostly work in
Data modelling.It would be handled by seperate team like
DBA team
Prabhu
www.iskilltech.com
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the tasks that can be performed using sq?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
how to load rows into fact table in data warehouse
Different circumstance which drives informatica server to expel records?
What does cheating measurement mean?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How do you set a varible in incremental aggregation
What do you mean by worklet?
What is a filter transformation?
What is a rank transform?