which quality process u can approach in ur project
Answer Posted / sambasivarao.m
In so many proccesses are followed in projects that depends
on project to project and client to client
|Is This Answer Correct ?||2 Yes||2 No|
How to load last n records of file into target table - informatica
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
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
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- firstname.lastname@example.org
What is a sorter transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
what is song in infrmatica...?
how to load dimension table and fact table. plz tell me the steps.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
can u any challenge your project?
how to create user defined function (udf) in informatica
How big was your fact table
How to do the error handling of if ur source is flatfiles?