how to get the data from the client machine and how to get server location data to client loction
can any one explain bit deep please..!
Answers were Sorted based on User's Feedback
Answer / koti
By using sytrics s/w we will connect with client machine
and its folders.... then only we can work directly in
client system ....
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / jeevan kumar medapati
By using informatica power connect we can connect
external(source system) system like mainframe,people soft
etc then we can import the source files to our
system(landing area).
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / moorthy g
Through Incremental Loading
(using mapping parameter)
so-sq(use SQL Override)-exp(SetMaxVaribale($$date, tr_date))-tar
Is This Answer Correct ? | 1 Yes | 10 No |
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
What if the source is a flat-file?
How to jion 2 tables, without using any condition?
What are connected or unconnected transformations?
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
Issue with Update override at Target table in Informatica.
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
How to display null values on a target & non-null values on a target?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
A session S_MAP1 is in Repository A. While running the session error message has displayed
What are the basic needs to join two sources in a source qualifier?