Interested to Buy Any Domain ? << Click Here >> for more details...
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
TCS,
3 6952How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
2177How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
1 6034How can we integrate different flat file data in a single mapping and with in a single execution
1 4557I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
TCS,
2 7527hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
1999following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
7 10561Post New Informatica Questions
expain about the tune parameters?
What is repository manager?
What are the tasks that source qualifier perform?
How to create or import flat file definition in to the warehouse designer?
how we can load rejected record's at run time?(not through bad files)
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
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Differentiate between a repository server and a powerhouse?
How do you use reject loader.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How can you increase the performance in joiner transformation?
What is the sql query overwrite in source qualifier in informatica
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Write the prerequisite tasks to achieve the session partition?
Partition, what happens if the specified key range is shorter and longer
