-
In my source table 1000 rec's are there. I want to load 501 rec to 1000 rec into my Target table ?
dl_mstr
- Feb 10th, 2008
SELECT *FROM (select * from source_table ORDER BY rownum DESC) SourceWHERE rownum <= 501
sreedhark26
- Mar 12th, 2007
u can load 500 records, then we can use Transaction control transformation, give the condition for 500 records out of 1000.
-
-
-
-
-
What is Session and Batches?
Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the session.Batches - It Provides A Way to Group Sessions For Either Serial Or Parallel Execution By The Informatica Server. There Are Two Types Of Batches...
Read Best Answer
Editorial / Best Answer
sanghala- Member Since Apr-2006 | May 14th, 2007
Session: A session is a set of commands that describes the server to move data to the target.
Batch : A Batch is set of tasks that may include one or more numbar of tasks (sessions, ewent wait, email, command, etc..,)
There are two types of batches in Informatica:1. Sequential: When Data moves one after another from source to target it is sequential
2. Concurrent: When whole data moves simultaneously from source to target it is Concurrent
ram_infa
- Sep 9th, 2011
Session is nothing, but it tells the integration service, when and how to move the data from sources to target
Group of sessions is called a batch..ravindra
- Jul 15th, 2011
Session is an object of repository,which instructs the informatica server(integration service)to execute the mapping with given database connection's...
-
Why we use lookup transformations?
Lookup Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks:Get a related value-Get the Employee Name from Employee table based on the Employee IDPerform Calculation.Update slowly changing dimension tables - We can use unconnected lookup transformation to determine whether the records already exist...
Read Best Answer
Editorial / Best Answer
Answered by: prodyot Sarkar
- Jul 31st, 2007
The following reasons for using lookups.....
1)We use Lookup transformations that query the largest amounts of data to improve overall performance. By doing that we can reduce the number of lookups on the same table.
2)If a mapping contains Lookup transformations, we will enable lookup caching if this option is not enabled .
We will use a persistent cache to improve performance of the lookup whenever possible.
We will explore the possibility of using concurrent caches to improve session performance.
We will use the Lookup SQL Override option to add a WHERE clause to the default SQL statement if it is not defined
We will add ORDER BY clause in lookup SQL statement if there is no order by defined.
We will use SQL override to suppress the default ORDER BY statement and enter an override ORDER BY with fewer columns. Indexing the Lookup Table
We can improve performance for the following types of lookups:
For cached lookups, we will index the lookup table using the columns in the lookup ORDER BY statement.
For Un-cached lookups, we will Index the lookup table using the columns in the lookup where condition.3)In some cases we use lookup instead of Joiner as lookup is faster than joiner in some cases when lookup contains the master data only.
4)This lookup helps in terms of performance tuning of the mappings also.
Satya
- Aug 9th, 2014
Use lookup transformation in a mapping to
--get related values
--perform complex calculation
--Handle slowly changing dimension.gazulas
- Apr 22nd, 2009
Thats a good question, suppose say you have 40 transformations in your mapping which invole complex agg, functions,? so in middle of the mapping there is a requirement to get the data from some? x t...
-
-
Interview questiontell me what would the size of ur warehouse project?
jayapraveen
- Oct 13th, 2010
For a banking domain if we are Maintaining customer infowarehouse the size of DB is 9GB1.4 dimensions-Customer,period or time,productand promotion2.7 fact tables3.approx min 45 mappings
vivek1708
- Jul 30th, 2008
I think the interviewer wants to the number of facts and dimensions in the warehouse, and not the size in GB's or TB of the actual Database.
-
What is the logic will you implement to load the data in to one fact from 'n' number of dimension tables.
ahammed
- Aug 2nd, 2010
First load the data into dimension table. If all the dimension data loaded is succeded then only load all dimension tables data into fact table.
-
-
What is the way to add the total number of records that have been read from SRC in the TGT file as last line?
What is the way to add the total number of records that have been read from SRC in the TGT file as last line? Let me clear you if my TGT is a flat file and want to add total number of records that are written in TGT as a last line with sysdate.
-
Target Details Verification
If the records are transfered from Source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.
Rishak
- May 21st, 2012
If you want to check the records,you can directly use MINUS query for eg
Hope this will help Thanks RishaCodeskaur29
- Nov 17th, 2011
1) Check Session Logs
2) Use Preview Data option for Target in PowerCenter once session is completed
3) Sql queries if it is a Relational database -
Union Transformation
Why Union transformation is active while it returns same number of rows as in the sources?
prashant.baranwal
- Sep 18th, 2010
Union transformation is an active transformation and it does changes the number of records.Suppose source has following columns:Name, School, CollegeABC, SKM, IIT-DXYZ, DAV, IIMThere are total 10 rows...
harikr
- Dec 1st, 2009
An active transformation can change the number of rows that pass through it. A passive transformation does not change the number of rows that pass through it.Union Transformation does UNION ALL; hence...
-
Aggregate Value
Explain a mapping design to start aggregating the values before getting all the rows from the source.
vijayant.sanjay
- Sep 7th, 2011
Agg t/f when using unsorted data, it do not perform agg calculation until it receives all the source rows from the pipeline, on the other hand when using sorted data for Agg t/f agg calculation starts...
jayapraveen
- Oct 4th, 2010
Here we taken this context as two ways aggregate value means for example if we take sales sum(sales)min(sales)max(sales)and the second context isfor the better performance we use the sorter before aggregator incoming values of the source
-
Typical Scenario - Schedule
Please help to set up following scenarioI have a source either file or db tableEno ename sal dept101 sri 100 1102 seeta 200 2103 lax 300 3104 ravam 76 1105 soorp 120 2Want to run a session 3 times.First time: it should populate dept 1Second time: dept 2 onlyThird time: dept 3 onlyHow can we do this?
MAHESH MANAM
- Sep 27th, 2012
We can solve this issue by the following types: First, we can create a mapping parameter and run the mapping in each time give the parameter value according to your requirement. Second, we can creat...
dileep671
- Jul 25th, 2012
Put this query in Source Qualifier select empno, ename, sal, deptno from emp_src where deptno not in (select deptno from emp_trg); Then connect it to Rank Transformation In the properties, Select To...
-
Execute Workflows Conditionally
I have 2 workflows named as W1 and W2 so I need to execute W2 but after W1 workflow executed successfully then only executed W2 workflow? How to do this one?
-
What are Aggregate transformation?
Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.
Read Best Answer
Editorial / Best Answer
Answered by: Praveen vasudev
- Sep 12th, 2005
Aggregator transform is m uch like the Group by clause in traditional SQL.
this particular transform is a connected/active transform which can take the incoming data form the mapping pipeline and group them based on the group by ports specified and can caculated aggregate funtions like ( avg, sum, count, stddev....e.tc) for each of those groups.
From a performanace perspective if your mapping has an AGGREGATOR transform use filters and sorters very early in the pipeline if there is any need for them.
veepee
sivakp
- Mar 13th, 2011
1. Aggrigator transformation allows to perform aggrigate calculation, such as SUM, MAX, MIN, FIRST, LAST2. Aggrigator transformation allows to perform aggrigate calculation of group.
shr_4
- Oct 27th, 2010
To perform Group by calculations we use Aggregator Transformation.It perform calculations similar to Expression Transformation.But difference between both is that Aggregator Transform...
-
Can we modify the data in flat file?
sppk
- Jul 18th, 2011
The update transformation/strategy uses the concept of keys, in order to update the target table. As flat file do not have any Keys defined on it, it is not possible to update the target,. which is a flat file.
Noel Lastra
- Apr 9th, 2008
You can modify the flat file using shell scripting in unix ( awk, grep, sed ).Hope this helps.
-
In the source, if we also have duplicate records and we have 2 targets, T1- for unique values and T2- only for duplicate values. How do we pass the unique values to T1 and duplicate values to T2 from the source to these 2 different targets in a single mapping?
Informatica Interview Questions
Read Best Answer
Ans