How to load data from excel to database using Informatica
Hi,i am just wondering if there is a direct way to load excel file into database using Informatica without having to convert excel to .Csv or XML format. Because we may have to load data from different excel worksheets.Thanks in advancesrini
How to join the data of two tables which does not have common columns
How to join the data of two tables which do not have common columni mean how to perform non equi join in Informaticaeg:just like getting data from emp and salgrade table of Oracle where sal is between losal and hisalthanksvenu
by using Lookup transformation
LKP Logic
in Condition port Sal
we can do it by taking lookup transformation
example you had taken is Emp table and sal grade table
LKP Logic:
in Condition port sal
with this Condition we can join two tables and get the data
Is it possible that a star schema contains more than one fact tables? If yes, how?
yes we can logical fact in terms of obiee in star scema
and also with then help of Confirmed dimension we can have another fact in starschema
NO
Ok its not good work environment by using multiple filter t/r usage Any way by using multiple filter we can load rejected rows also SD-->SQ-->fltr(condition(true)(eg:deptno=10)---->loaded into one tar...
You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition...
Hi all i have been etl Informatica developer for last few years.I am good at SQL and UNIX.I need some guidance for my career.I wanna learn bo or any other reporting tool along with etl.I wanna learn anything more which could help my career .I just some guidance from all of you.Please help. thank you prithvi
my suggestion is ETL tools having lot of demand in Market so better don't change path and try to learn Datastage or another ETL tools.
Performance tuning in Informatica
What is performance tuning in Informatica? How it can be done?
Looking at logs, we can identify which thread(Reader/ Writer/ Transformation) is taking time to process. Below are the options to improve performance: Mapping level changes--> 1. Move the filter T/f a...
optimizing the session performance is known as performance tuning.the session runs in the availabale load window for the informatica server.performance tuning can be achieved in so many ways.1.use the...
Hi all! I am a fresh graduate in nigeria, looking forward to working with one of the big fours soon as a member of the it advisory team, what it tools would you advice I get acquainted with while I work towards my recruitment, secondly, can someone please enlighten me on the areas of erp I need to take...
How to call SQL stored procedures in Informatica?
Using Store Procedure t/r call it
Through one session how we load half of data from flat file on 1st run of session and on 2nd run of the same session it load rest half of data to the same target ?
Create two session which points to the same mapping and parameterise the source qualifier query in a way that it picks first half record for the first session run and second half for the second sessio...
Cumulative sum using Java transformation
How to find cumulative sum using Java transformation? consider the following employees data as source employee_id, salary 10, 1000 20, 2000 30, 3000 40, 5000 the target table data should look like as employee_id, salary, cumulative_sum 10, 1000, 1000 20, 2000, 3000 30, 3000, 6000 40, 5000, 11000 *****how...
Send flat file data to different targets
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file without adding extra columns?
For the FlatFiles, in source definition, there is a option to include file name as one of the output port. There is no need to add FileName in actual source file. Informatica will append it to every r...
first thing i would like to know is whether the different targets are of same database or not. If the target is from same database then you can use router transformation by importing the flat file into source either as de-limited or fixed width.
How to generate a file based on location.
Hi, i have a requirement and I have created a mapping and I need to generate a single file based on location. ex: my server placed into us location and I will kick of my wf from uk so I need to create a uk file. col1 col2 location aaa bbb uk xyz ccc uk if I ran my wf from us location the...
How can you minimize the cache size for a joiner transformation?
Q. How can you minimize the cache size for a joiner transformation? (a) make the smaller source the master source. (b) make the smaller source the detail source. (c) sort the master data prior to the joiner transformation. (d) sort the detail data prior to the joiner transformation.
A.Make the smaller source the master source.
What are the different tracing levels and how it is used?
A Tracing level determines the amout of the information in the session log.or it store the information in session log. we have 4 types of Tracing levels 1.normal,2.verbose,3.verbose data,4.terse defa...
Incremental aggregator transformation
If incremental aggregation option is checked in session properties will the new cache is created during every run?
Incremental aggregation creates a cache memory in the first run, in each successive runs, the cache is updated with new records( apart from the old records). Same cache but updated records. So you ha...
What is subject area?
May be 18 transformations are there in Informatica. They are source qualifier, sorter, filter, router, aggregator, expression, update strategy, store procedure, sequence generator, external procedure,...
I think this is obiee question anyway , subject area is a presentation service equivalent to presentation catalog in bi server .
What is the difference between fact and measure?
Measures are calculations based on facts. A measure points to a fact (such as order amount) and specifies an aggregation function (such as average or sum).
the real meaning of fact is what are all the necessary information for a business.Ex: in a business, customer,item,order,invoices tells information.calculation of amt to be paid by the customer is the...
Which transformation can perform the non equi join?
BY USING LOOKUP T/R WE CAN JOIN NON EQUI JOINS
Non Equi Join is same as outer join in join transformation. So we can do by using the joiner in Informatica.
Can you implement SCD type1 1 and SCD type 2in the same mapping ?
Yes we can do it
Yes we can.
Hi
Go to source and create required ports and send to Expression..there we need to converted the delimiter file or Comma separate file by using the ltrime and rtrime values...and send to target ....
convert excel file to .csv and then csv to text file...then u can take the source as flatfile..