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

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

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

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

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 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

Anil Jaiswal

• Jun 21st, 2017

Using this command: sed -i $ d filename

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

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

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

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

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

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

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 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

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

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

In which situation do we use update strategy?

Anil

• Jun 22nd, 2016

If we want to perform 2 DML operations but same operations it is not better to use update tr. use property in session (treat source rows as) instead of creating update tr. If we want to perform 2 DML...

ankit

• May 4th, 2016

Can any one tell me in which scenario it is not advisable to use update strategy?

Answer Question  Select Best Answer

How to load top/last 3 record using parameter file in Informatica?

Anil

• Jun 22nd, 2016

Parameter files are meant to standardize business rules we can specify, from what column the data is to be extracted and loaded but I think it is not possible to load top/last 3 record by parameter file?

janardhanan

• Jun 12th, 2016

Using Rank Transformation

Answer Question  Select Best Answer

If 5 records are there in source, how will you make 10 in targets (double the number of records in source, duplicate source records)?

Anil

• Jun 22nd, 2016

We can do it by taking expression t/r and 2 instances of same target and connecting from same exp to 2 targets!

Anupam Kumar

• Apr 8th, 2016

Use Router. Create two group and just put TRUE in both

Answer Question  Select Best Answer