By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?14 36499
In real time scenario where can we use mapping parameters and variables?4 27426
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 12975
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 5249
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.10 26698
How to generate a single mapping for both the historical and incremental load.2 5492
What are the uses of a Parameter file?3 9684
what are the limitations for bulk loading in informatica for all kind of databases and transformations?3 10707
when we dont use aggregator in mapping ?2 4179
How many joins in Informatica5 19301
How to identify this row for insert and this row for update in dynamic lookup cache3 6338
What is router transformation4 3575
How to eliminate duplicates in FF and oracle both3 4149
If I am having 6 flat files in data. How can you load the data at a time2 4785
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 5662
DO YOU NEED A LOAN? Good morning my dear brothers and sisters in Christ, I am Mr Blair James, a reputable, legitimate and accredited money lender. I loan money to people in need of financial assistance at 3% interest rate. Do you have a bad credit or are in need of money to pay bills? Let me take this medium to inform you that I assist beneficiary reliable as I'll be glad to offer you a loan.Please write with the below information. After the reply, you will be sent a loan application form to fill. (There are no credit check, 100% Guaranteed!) I hope you will allow me to be of service to you. Sincerely. Contact us via email: (firstname.lastname@example.org) with the Applicant Information below: Full Name;Country:Amount Needed;Monthly Income:
I done MBA (HR-MARKETING) and now am working for some other company, i want to do PGDIPLOMA IN BUSINESS MANAGEMENT OR HRM. Can any one suggest which univercity is best and is this right decision..?
Can anyone forward me EP faqs to the following mail id: email@example.com Thanks in advance
Difference between main program and a sub program in PL/1?
pls send me the syllabus questions on rrb section engineer (telecom)
Hi, Give me some scenario's where we use gap and how we use gap in sap fico.
Explain howyou would account for the following items/situations,justifying answers by reference to the conceptual frameworks defintion and rcognition criteria. a)A trinket of sentimental value only b)You are the guarantor for your friends bank loan i) You have no reason to belive that your friend will default on the loan ii) As your friend is in serious financial dificulties,you think it is likely that he will default on the loan c)You receive 1000 shares in X Ltd,trading at $4 each,as a gift from a grateful client. d)The panoramic view of the coast from your cafes windows,which you are convinced attracts customers to your cafe
How can we calculate the per hour productivity of a hydraulic rock breaker,for excavator..
explain principle of potentiometer
caurren capacity calculator of Copper and aluminium wire
why would amp draw on neutral wire be as much as amp draw on the hot leg.
for linear polarisation antenna how do u measure polarisation?
How DC earth leakage currents can be reduced ?
Types of errors in account
Why are like to work in my company?