Can we update target table without using update strategy transformation?

MAHESH MANAM

• Aug 22nd, 2012

Yes, By using session level properties. In that use follow the steps Session --> Edit --> Properties --> Treat source rows as --> Update and also you should check options in Mapping --> Target --> U...

pranyarockvi

 Profile Answers by pranyarockvi Questions by pranyarockvi

• Jul 30th, 2012

Yes we can , it is the just that update strategy is used for conditional updates, and the update option available at the mapping level in the target is update without any condition.

Answer Question  Select Best Answer

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

Staging area may be required if you have any of the following scenarios: Delta Loading: Your data is read incrementally from the source and you need an intermediate storage where incremental set of y...

MAHESH MANAM

• Aug 16th, 2012

It is a automated process of building a data warehouse which involves taking the data from disparate source systems, converting them into a consistent form that can be loaded into the warehouse and pe...

Answer Question  Select Best Answer

Can any one please tell me how to explain Manufacturing Domain Informatica project in interview as a ETL Developer and from where to start and end.

pradyumna sahoo

• Jan 28th, 2015

Shortly u describe your projects like project name ,& which domain u work? basically u tell your project architecture and its flow .

vijay

• Nov 27th, 2012

Start your project description, then move on to your role and responsibilities and then about your team and so on...

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

Which means the first record should come as last record and last record should come as first record and load into the target file?

sandeepsandeep

 Profile Answers by sandeepsandeep Questions by sandeepsandeep

• Aug 11th, 2014

In the Sequence generator, write the query and then order by DESC. this will do a reverse of all records first will go last and last will go first.

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Jul 14th, 2014

This is pretty simple.

Use sequence generator to number the records.

Then sort them in descending order using sorter transformation.

Answer Question  Select Best Answer

Gayathri

• Jul 21st, 2014

Go to Session Properties->Config.Object, Make Stop on Error as 0.
This will not fail the session if there is error in 1 record. This will load all error free records.

Dinesh

• Jul 21st, 2014

If the source is FF, then use skip first 299 rows and then start loading.

If the source is relational then u row number.

Answer Question  Select Best Answer

How to tune the session,workflow for better perfomance,what are the things we consider for better performace?

Ruhi

• Feb 1st, 2016

Partitioning, line sequential buffer length, tracing level as terse, collect performance data as enabled, commit interval are some of the pointers for session level performance tuning.

Rajesh Kumar

• Sep 16th, 2014

Make sure the Sorted Inputs enabled for Joiner, Lookup and Aggregate transformations in workflow.
Use Dynamic cache for lookups whenever needed otherwise cache takes more spaces (instead of cache)

Answer Question  Select Best Answer

Hi All,

I am faced with a scenario wherein while data flow from source to target, a condition would be checked that if the data is present in target then a source column will be updated as U and if the data is not present in target then the source column will be updated as I

Vipin

• Nov 11th, 2014

Lookup the target table based on key and check either record is exist or not. If Lookup returns any record then By using update Strategy update or insert. Note : to update record using Update Strategy you need to apply Primary key at INFA Laval at least otherwise it wont work.

KJ

• Nov 10th, 2014

Its never the source but the target column that gets updated with U or I to identify the updated or newly inserted rows.

Answer Question  Select Best Answer

What is meant by informatica grid? what are the component of informatica grid?

Fabio Mendon?a

• Mar 31st, 2016

When I use a grid in a Workflow and my second session (S2) has distributed on 3 links .... Question: The process that run on link 1 (S1 , S2 , S3 , S4, S5) , get the same link until the end (S5) ?...

Pruthvi S

• Dec 21st, 2014

A grid is an alias assigned to a group of nodes that allows you to automate the distribution of workflows and sessions across nodes. When you use a grid, the Integration Service distributes workflow...

Answer Question  Select Best Answer

Source
id,name
1,a
2,d
3,c

Target
detail
((1/a)(2/b)(3/c))

Manas

• Feb 4th, 2015

We can use expression transformation here in which we can define variables that store the string in the below mentioned way: var1=var1||(||id||/||name||) output_port=(||var1||) After this w...

XYZ

• Feb 4th, 2015

Using a Union Transformation

Answer Question  Select Best Answer

I am new to Informatica and learning it, Can anybody please tell me how we receive source as flat file in informatica? From where we get this flat file?

yusuf

• Feb 20th, 2016

You create a one note in desktop and insert the data with delimiter as you require and save it . Go to source qualifier and import as flat file and import from desktop.

xyz

• Feb 19th, 2016

We need to create the Flat file or import the file if already exists. Source Analyser--> Create or Import file

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

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

In SCD Type 2 Mapping, I Have 50 Records. How to compare without going record by record?

DEEKSHA

• Mar 12th, 2019

Use joiner transformation, instead of lookup to target table.

Arpit Gautam

• Nov 1st, 2018

Use MD5 check constraint in Expression transformer

Answer Question  Select Best Answer

How can we do incremental loading if the source is flat file?

Jacqueline

• Aug 23rd, 2023

Ratnesh, your answer is fine if we know what the natural keys are but what happens if the file is extremely large and you have no idea what the keys are in the flat file? If that is the case then I ...

Ratnesh

• Dec 31st, 2020

If your source flat file is always full file , based on the natural keys, you can identify the records by lookup on the target table , whether records are existing or new. If records are new, go ahead...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

deepthi_97  

 Profile Answers by deepthi_97 Questions by deepthi_97

• Member Since Sep-2009 | Sep 23rd, 2009

---

Cobol files and we use normalizer transformation

deepthi_97

 Profile Answers by deepthi_97 Questions by deepthi_97

• Sep 23rd, 2009

Cobol files and we use normalizer transformation

Prabu

• Jun 22nd, 2007

The mainframe files are Used as VSAM files in Informatica by using the Normaliser transformation

Improve Answer

Mapping designer Tansformation developer Mapplet designer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 12th, 2009

A transformation is a repository object that generates, modifies, or passes data.  We can create transformations in three ways:1. Transformation Developer - Used for creating reusable transformat...

chandrarekha

• Sep 7th, 2007

Mapping DesignerMaplet DesignerTransformation Deveoper?- for reusable transformation

Answer Question  Select Best Answer

Two ways 1.Drag the port from another transforamtion 2.Click the add buttion on the ports tab.

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 21st, 2009

Ports are columns in Informatica Transformations.Ports can be created in 2 ways.1]. We can drag the ports from source qualifier to any type of transformation.2]. Double click on Header of Transofmrati...

Nitin Rane

• Jun 13th, 2007

We can copy and paste the ports in the ports tab

Answer Question  Select Best Answer

Reusable transformations can be used in multiple mappings.When u need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation ,all instances of it inherit the changes.Since the instance of reusable transforamation is a pointer to that transforamtion,U can change the transforamation in the transformation developer,its instances...

devaranr

 Profile Answers by devaranr Questions by devaranr

• Apr 12th, 2007

1. A reusable transformation can be used in multiple transformations2.The designer stores each reusable transformation as metada separate from   any mappings  that use the transformatio...

zaki

• Apr 1st, 2007

Hai to all friends out therethe transformation that can be reused is called a reusable transformation.as the property suggests it has to be reused:so for reusing we can do it in two different ways 1) ...

Answer Question  Select Best Answer

The aggregator stores data in the aggregate cache until it completes aggregate calculations.When u run a session that uses an aggregator transformation,the informatica server creates index and data caches in memory to process the transformation.If the informatica server requires more space,it stores overflow values in cache files.

chandrarekha

• Sep 24th, 2007

when? server runs the session with aggregate transformation ,it stores data in memory until it completes the aggregation when u partition a source ,the server creates one memory cache and one disk ca...

bneha15

 Profile Answers by bneha15 Questions by bneha15

• Apr 18th, 2007

Aggregate cache contains data values while aggregate calculations are being performed. Aggregate cache is made up of index cache and data cache. Index cache contains group values and data cache consists of row values.

Answer Question  Select Best Answer