Search:

Type: Posts; User: reetasharma108; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.02 seconds.

  1. Answers
    5
    Views
    3,046

    Data Warehousing - Re: Identify New Records

    Hi,

    You can use lookup transformation to identify the records presents in the target table.
    here target table will be lookup table.after that you can put one router to insert/update new records
    ...
  2. Answers
    3
    Views
    7,714

    Data Warehousing - Re: Tools related to Datawarehousing

    Number of the ETL tools are available for the data warehouse like
    1.Informatica
    2.Data Stage
    3.Abintio
  3. Answers
    3
    Views
    7,714

    Data Warehousing - Re: Tools related to Datawarehousing

    Data Warehouse is collection of data from different operational systems in to one place.we can read,write,modfy the data as per requirement similar like the database.but main difference between...
  4. Answers
    2
    Views
    2,195

    Data Warehousing - Re: XML Object Mapping

    you can import this in source analyzer and make use of it as source.
    In designer> source analyzer> import>XML_File
  5. Answers
    5
    Views
    3,093

    Data Warehousing - Re: What is meant by centralised dwh?

    Centralized DWH means all the related data (collected from different ODS) is place in one database.rather than in a seperate DBs.
  6. Answers
    5
    Views
    3,093

    Data Warehousing - Re: What is meant by centralised dwh?

    centralised dWH means all the datamarts used to load DWH are placed at one centralised location.

    Reeta
  7. Answers
    2
    Views
    2,337

    Data Warehousing - Re: data warehousing

    for this you can create target as an flat file,either fixed width or delimited.
    In the warehouse designer there is option for target.go there and click on create option.there you can choose flat...
  8. Answers
    3
    Views
    2,267

    Data Warehousing - Re: data warehousing

    yes
    we can do that.import those file using the import tab in mapping designer.

    Reeta
  9. Answers
    3
    Views
    2,529

    Data Warehousing - How to read files using informatica

    Hi,

    I have unix directory, where i got different number of files daily.
    Now i have to read these files using informatica.I cant use variable or parameter.
    can anybody suggest me any idea for...
  10. Data Warehousing - Re: Identify the connected and unconnected transformation

    Connected transformation:- this transformation will connect to other tansformations in mapping and will take input from pipeline.

    Unconnected:-it is not connected to pipeline. input to this...
  11. Data Warehousing - Re: How to load data (key range) to 3 worksheets

    for this create the source partitoning and make three targets on the base of key range.In the session properties we can define the sql query with key range so tht each qualifier read only tht range...
  12. Answers
    5
    Views
    4,089

    Data Warehousing - Re: Writing query with LEFT OUTER JOIN

    I will take but make sure database is oracle.
  13. Answers
    4
    Views
    2,463

    Data Warehousing - Re: I am having one dimension

    ya sure can do that.for retrieving from a dimension(table) it is not necessary to have join on that.u can use simple select statement.
  14. Answers
    7
    Views
    3,388

    Data Warehousing - Re: Duplicating one row into two rows

    First if you want to make duplicate records in target table then u can drag those columns from source qualifier to target table two times, But please make sure tht there should not be any type of...
  15. Data Warehousing - Re: Kill a process which has been started in Informatica

    login to the inormatica repository then go to required folder.after thar right click on the required workflow, there will be an option of stop. chosse it,then ur workflow will stop and hence one...
  16. SQL Re: Where does the execution stops exactly

    Execution will stop as soon as exception occur in procedure b.
  17. Answers
    7
    Views
    3,176

    SQL Re: Can we use procedures within Views

    ya we can use view in procedures
  18. SQL Re: Second highest number from a list of numbers

    Hi,

    For getting second highest number u can try following query:-

    select unitprice from (select rownum r, unitprice from (select unitprice from products order by unitprice desc)) where r=2;
  19. Thread: Sql

    by reetasharma108
    Answers
    2
    Views
    1,974

    SQL Re: Sql

    Hi,
    syntax for query is:-

    select salary from emp_table where salary between 70000 and 100000
    and salary_4_day between sysdate-90 and sysdate;
  20. Answers
    5
    Views
    5,620

    General Re: SELECT query processing

    HI,

    As soon as u enter any SQL query, internally three processes occur:-
    1.in first process the syntax error is checked.
    2. second process is called parsing,in this oracle check whether the...
  21. Answers
    2
    Views
    6,929

    General Re: Database VS data warehouse

    hey Lucy,

    If you dont mind can you please tell me the 5 diffrence u know?because i know only one.
  22. Data Warehousing - Re: File having 12 records I have to send data to different targets

    By using Router transformation of the informatica u can do this.
    in router u can give these three condition and defined ur target in user defined output group.on the behalf of the condition the...
  23. SQL Re: Retrieve the data which are only duplicates

    select * from table_nm where column_nm in(select col_name from table_name group by col_nm having count(1)>1);
    for example:-

    select * from emp where job_id in (select job_id from emp group by...
  24. SQL Re: How can I add the locations to the existing members

    ya u can do that..................

    As u r saying you have inserted new column so for inserting the values in that column u can use following:-

    update emp_table set LOC='ABC' where emp_no=123;
    ...
  25. SQL Re: Extract the table name by using its column name

    Hi,

    It is not possible to get the table name by taking the reference of a column name.
Results 1 to 25 of 46
Page 1 of 2 1 2
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact