rakesh

• Jul 20th, 2016

No because if given in a tabular form then it would easily understandable and readable

anilkumarin1

 Profile Answers by anilkumarin1 Questions by anilkumarin1

• Dec 30th, 2008

A shortcut is a reference (link) to an object in a shared folder, these are commonly used for sources and targets that are to be shared between different environments / or projects. A shortcut is crea...

Answer Question  Select Best Answer

Normal (Default) Master outer Detail outer Full outer

ravi ranjan

• Jul 22nd, 2016

Joiner transformation having four types
1 Normal join
2 Master outer join
3 Detail outer join
4 Full join

Kiran Ghatage

• Nov 15th, 2014

Look into following mappings
https://community.informatica.com/solutions/developer_client_full_outer_join

https://community.informatica.com/solutions/developer_client_self_join_using_joiner

Answer Question  Select Best Answer

I have installed Informatica 7.1.1 and Oracle.But the Informatica server service starts momentarily and then stops.I have uninstalled and installed Informatica twice and removed from the registry as well, but the problem persists.Does any body have the solution for this

pulak

• Aug 3rd, 2016

Informatica error - server service starts momentarily and then stops to resolve this kind of issue 1. check whether your Repository user is locked 2. check whether your Repository user pass is ex...

krkreddys

 Profile Answers by krkreddys Questions by krkreddys

• Aug 8th, 2014

It is because of your Repository user is locked/(database not open). Go to oracle database Repository user try to login to repository, then unlock it. It works fine.

Answer Question  Select Best Answer

Which of the following statements is correct on workflow events?

1) A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping.

2) A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon...

Visal

• Aug 14th, 2016

Event wait will be completed once the specified event occurs or in other words, it will wait for the event-raise activity to raise that particular event. You can create an event-raise to poll for a ...

milind

• Jul 12th, 2016

There are options which we have to select eg. to delete file after reading etc.,

Answer Question  Select Best Answer

I am loading records from a source table to a CRM target table. I want to get the details of the manually inserted, updated, deleted records from the target table. Please explain in detail.

Nilesh Hajare

• Sep 22nd, 2016

You can check the user id column of CRM object.

Answer Question  Select Best Answer

Inner equi join.

Aaradhya

• Nov 10th, 2016

The Joiner transformation supports the following join types, which you set in the Properties tab: Normal (Default) Master Outer Detail Outer Full Outer Default join is Normal Join/Inner Join/Equi-Joi...

Vikas Dhakne

• Aug 8th, 2016

Source Qualifier transformation supports following types of joins:
1.Normal/Equi join
2.Left Outer Join
3.Right Outer Join

Answer Question  Select Best Answer

Vikas Dhakne

• Dec 15th, 2016

UNION transformation combines 2 sets of same attributes. If you use sequence generator transformation before union, it will give duplicate values (because sequence is coming from different sets). henc...

Answer Question  Select Best Answer

What is use of UNIX in Informatica? Where and how can we use UNIX shell scripts or commands to run informatica jobs or other related applications in informatica?Please tell in details as i am working on windows environment, but will be shifted to UNIX environment. Please describe in details starting from installation of informatica in UNIX to run or guide the working on informatica in Unix environment.

Amit Tarafder

• Feb 16th, 2017

Informatica is installed on Unix servers. Unix is used to run different shell scripts in server environment through
Informatica command tasks.

sriluck

• Sep 24th, 2007

HiThese are some ways unix works with Informatica.1) In unix box, we can create a SCRIPT which calls informatica session  and make the session run.2) We can UPDATE STATISTICS or CLEANUP files by ...

Answer Question  Select Best Answer

Is it possible to use SCD Type-2 without using Lookup in the mapping?If it is possible please let me know. How it will be possible?

ashwin

• Mar 22nd, 2017

SRC-->SQ--> JNR-->EXP-->RTR-->TGT(Insert for both new and updated records) SRC(TGT)-->SQ--> -->TGT(Update The entire implementation will be same as that using a l...

ashwin

• Mar 22nd, 2017

The entire implementation will be same as that using a lookup. The only thing we need to replace the Lookup transformation with a Joiner transformation. In the Joiner transformation the Source table w...

Answer Question  Select Best Answer

How can we receive source as flat file in informatica, from where we get this flat file?

sri

• Jun 18th, 2017

We get flatfile from source to target, which is in file format like MS-Word, etc

Anil

• Jun 22nd, 2016

To explain it clearly we have to know the concept of using FTP. Consider a banking project, the product owner gives all data to production team and not to developer, the 3rd party team gives another d...

Answer Question  Select Best Answer

Anil Jaiswal

• Jun 21st, 2017

Using this command: sed -i $ d filename

Answer Question  Select Best Answer

saiteja

• Jul 2nd, 2017

Rank is an active and connected transformation rank transformation contain inputport, outputport, variableport, rankport by using rank transformation we can get top (or) bottom ranks
rank transformation

arun singh

• Mar 8th, 2017

Use rank transformation to return top or bottom N-no of position, it uses rank cache to perform rank. In rank cache it contains both index as well as data cache. Index cache contains GROUP BY parts, w...

Answer Question  Select Best Answer

Why do we need transformations like filter, sorter, Joiner etc when we can do all those tasks with Source Qualifier itself using queries?

anand

• Jul 15th, 2017

Because of whenever we are getting data from tables then src_quli works, not for filedata

jatin

• Jun 8th, 2017

Its because in source qualifier you can make the transformations like join, filter only with homogeneous sources like tables can only joined with tables. But if you have to join a file and a table the...

Answer Question  Select Best Answer

saiteja

• Jul 24th, 2017

There are 2 types of loading in the Informatica 1) Normal load 2) Bulk load When you configure the load as normal load it process the row by row the normal uses log file for restartability When ...

Anonymous

• Jul 21st, 2016

Can we know what type of loader is used by Informatica to load data in to Oracle database?

Answer Question  Select Best Answer

source: target:
col1 col2 col1 col2

a 1 1 a,b,c,d
b 1 2 p,q,r
c 1 3 x
d 1
p 2
q 2
r 2
x 3

how to do this...

Thanks,
krishna.

rashmi

• Aug 12th, 2017

We can use aggregator transformation.say col1=Nme,col2=ID
Make new_name and new_no as variable port.Specify condition as New_name=IIF(new_no=ID,new_name||,||name,name)
new_no=ID
Give one output port say Output_name =New_name

suresh

• Apr 30th, 2017

I have to pivot the source data from column to rows till "transform" value, "transform" value can occurs any one of the columns, please advice me suggestions, Can any one help me how to achieve the be...

Answer Question  Select Best Answer

If I have a source as below:Employeed, FamilyId, Contribution1,A,100002,A,200003,A,100004,B,205,B,20________________________________And my desired target is as below:EmployeeId,Contribution(In Percent)1,25%2,50%3,25%4,50%5,50% ____________________________________________________________________________Explanation: The contribution field in target is the individual Employee's share in a family's contribution.Say...

Mohan Krishna Bellamkonda

• Sep 7th, 2017

Code
 

Mohan Krishna Bellamkonda

• Sep 7th, 2017

Code
 

Answer Question  Select Best Answer

Dhiraj Chachane

• Sep 28th, 2017

Hi anybody Can you let me know about how to load flat files to target without mappings?

Sarita

• Oct 23rd, 2013

The daily routines of the developer in support role: 1)Do lights on activity,i.e. check if the informatica services are running,any session failed or not,if a file failed then how many records loaded ...

Answer Question  Select Best Answer

How to create a session log as a parameter in informatica cloud?

sailaja

• Oct 23rd, 2017

At session level if we click on general option you will find session log file, session log folder. We can perameterise those. (ex: $session log file)

Answer Question  Select Best Answer

I am not able to understand the different between PreSql in Source Qualifier and PreSQL in Target in Informatica. I read many other posts they told

pre SQL means " SQL statement executed using the source connection,before a pipeline is run" and post SQL means " SQL statement executed using the source connection,after a pipeline is run".

So if all PRESQL run at same point...

Anurag

• Nov 27th, 2017

Pre-SQL in SQ is use to run the SQL in source database and similarly preS-QL in target for target DB.
This is useful when the source and target database are different .

Answer Question  Select Best Answer

What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?

Read Best Answer

Editorial / Best Answer

sarun5  

 Profile Answers by sarun5 Questions by sarun5

• Member Since Feb-2008 | Mar 13th, 2008

---

Guys I have got the answer for which I asked..here you go

This can be handled by using the file list in informatica. If we have 5 files in different locations on the server and we need to load in to single target table. In session properties we need to change the file type as Indirect.
(Direct if the source file contains the source data. Choose Indirect if the source file contains a list of files.
When you select Indirect, the PowerCenter Server finds the file list then reads each listed file when it executes the session.)
am taking a notepad and giving following paths and file
names in this notepad and saving this notepad as
emp_source.txt in the directory /ftp_data/webrep/

/ftp_data/webrep/SrcFiles/abc.txt
/ftp_data/webrep/bcd.txt
/ftp_data/webrep/srcfilesforsessions/xyz.txt
/ftp_data/webrep/SrcFiles/uvw.txt
/ftp_data/webrep/pqr.txt

In session properties i give /ftp_data/webrep/ in the
directory path and file name as emp_source.txt and file type as Indirect.

Anurag

• Nov 27th, 2017

You should use a indirect file (which contain path and name of all the 5 files) as source. Transformation depends on the business logic.

Ashok Gulagond

• Dec 16th, 2016

When we have the same structured flat files, why don't simply use UNION make them a single file and then load to target instead of such complication? or UNION doesn't work on flat files?

Improve Answer