By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?14 35644
In real time scenario where can we use mapping parameters and variables?4 27021
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek5 12490
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,3 5073
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.10 25858
How to generate a single mapping for both the historical and incremental load.2 5307
What are the uses of a Parameter file?3 9267
what are the limitations for bulk loading in informatica for all kind of databases and transformations?3 10158
when we dont use aggregator in mapping ?2 4032
How many joins in Informatica5 18750
How to identify this row for insert and this row for update in dynamic lookup cache3 6124
What is router transformation4 3431
How to eliminate duplicates in FF and oracle both3 3992
If I am having 6 flat files in data. How can you load the data at a time2 4640
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? Thanks4 5435
We are running an educational institution in Karnataka,India. Is there any ceiling stating that if gross salary is upto this then only incentive or bonus can be paid?
am commissioning the trafo without connecting the neutral therefore unbalance will occur what is the alternative solution for this?
I AM A ELECTRICAL PANEL BOARD DESIGN ENGINEER.IF I GO ANY INTERVIEW ,TECHNICALLY WHAT ARE QUESTIONS I WILL FACE FROM INTERVIEWER?
What are register in India localisation?
In General please do read newspapers.And be thorough with 10th history and Geography.Biology also
explain code with datachaching with example
sir i have 4 year gap in engineering. i would complete my degree b.tech it in 2014. it will be may be in 2nd class.my hsc is also with 2nd class. i am week in programming. Then if i want highest package upto 5-6 lacs then what should i prepare myself as a good engineer to get this package???
What experience have you had in personnel administration?
What is the maximum amount to issue Form C to a dealer for the purchase of 40 crores in several bills in a quater?
HOW MUCH CURRENT DOES SYNCHRONOUS MOTOR TAKES AT SYNCHRONOUS SPEED IN NO LOAD CONDITION ?
How can increase strength of EMF in AC motor?
What is signatures?
From where I should start to prepare for cat?
What are parameters needed to distinguish an event ?
How can i load all the data from a file to Table (array) in cobol.How i manage the occurs clause with out reading the file.Any options avilable ? Please can any one help me it is urgent?