UrbanPro
true

Learn Informatica from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Learn Informatica with Free Lessons & Tips

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Answered on 20 Feb Learn Informatica +1 SAP

Sana Begum

My teaching experience 12 years

1.0 Creation of SAP Data Store. Expand the “SAP_TTL_Client100_DS” datastore. Select the IDOCs and Right click , click on “Import By Name…”1.1 IDOC'S importing.1.2 IDOC Import by Name. Provide Type & Name as shown above & click on “Import” to import IDOC in data-store.
Answers 2 Comments
Dislike Bookmark

Answered on 20 Feb Learn Informatica +1 SAP

Sana Begum

My teaching experience 12 years

Hello Anil, No, SAP BODS (Business Objects Data Services) is not a database tool. Instead, it is an ETL (Extract, Transform, Load) tool designed for data integration, transformation, and migration. While databases store and manage data, ETL tools like BODS are responsible for the movement and transformation... read more
Hello Anil, No, SAP BODS (Business Objects Data Services) is not a database tool. Instead, it is an ETL (Extract, Transform, Load) tool designed for data integration, transformation, and migration. While databases store and manage data, ETL tools like BODS are responsible for the movement and transformation of data between different systems. Regards read less
Answers 2 Comments
Dislike Bookmark

Answered on 20 Feb Learn Informatica +1 SAP

Sana Begum

My teaching experience 12 years

The most important thing to note is that a join and the lookup functions are not always functionally similar. Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select... read more
The most important thing to note is that a join and the lookup functions are not always functionally similar. Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select the most relevant row in the case of multiple matches). There are various aspects to the performace of both mechanisms, but you only need to be concerned with this if you have performace issues. read less
Answers 2 Comments
Dislike Bookmark

Learn Informatica from the Best Tutors

  • Affordable fees
  • Flexible Timings
  • Choose between 1-1 and Group class
  • Verified Tutors

Answered on 20 Feb Learn Informatica +1 SAP

Sana Begum

My teaching experience 12 years

Syntax error in BODS Script.Connectivity issue between BODS and Source/Target Table.RFC Connectivity issue.Parent process died issue - Job will terminate unexpectedly.Sheet name mismatch in Source Excel Workbook.Source/Target Table Structure Changes.Back end repository Tables Corrupted.
Answers 2 Comments
Dislike Bookmark

Answered on 20 Feb Learn Informatica +1 SAP

Sana Begum

My teaching experience 12 years

input ports are associated with the source data, specifying the columns that are read or extracted, while output ports are associated with the target data, specifying the columns that are written or loaded. The mapping between input and output ports is crucial for ensuring that data is properly transformed... read more
input ports are associated with the source data, specifying the columns that are read or extracted, while output ports are associated with the target data, specifying the columns that are written or loaded. The mapping between input and output ports is crucial for ensuring that data is properly transformed and moved from source to target in a BODS job. read less
Answers 2 Comments
Dislike Bookmark

Answered on 09 Jan Learn Informatica +1 SAP

Akshay Godhamgaonkar

Experienced & Certified SAP FICO Trainer; 11+ Yrs Exp.; MBA Finance

Yes, it is possible to migrate BODs jobs into Informatica ETL tool. However, there are some differences between these two tools. For ex, in BODS, there is a concept called Template tables which will automatically useful to create source schema. But in Informatica, we need to manually create source schema... read more

Yes, it is possible to migrate BODs jobs into Informatica ETL tool. However, there are some differences between these two tools. For ex, in BODS, there is a concept called Template tables which will automatically useful to create source schema. But in Informatica, we need to manually create source schema every time12. Similarly, in BODS, there are SQL scripts which we can use to achieve business logic before or after a job is finished. In contrast, in Informatica, we need to manually export jobs.

read less
Answers 2 Comments
Dislike Bookmark

Learn Informatica from the Best Tutors

  • Affordable fees
  • Flexible Timings
  • Choose between 1-1 and Group class
  • Verified Tutors

Answered on 20 Feb Learn Informatica +1 SAP

Sana Begum

My teaching experience 12 years

Yes, it is possible to migrate Business Objects Data Services (BODS) jobs into an Informatica ETL (Extract, Transform, Load) tool. This process typically involves analyzing the existing BODS jobs, understanding their logic and requirements, and then redesigning and re-implementing them in the Informatica... read more
Yes, it is possible to migrate Business Objects Data Services (BODS) jobs into an Informatica ETL (Extract, Transform, Load) tool. This process typically involves analyzing the existing BODS jobs, understanding their logic and requirements, and then redesigning and re-implementing them in the Informatica ETL tool. It's important to note that this migration process may require careful planning and testing to ensure that the functionality and performance of the original BODS jobs are preserved in the new environment. read less
Answers 2 Comments
Dislike Bookmark

Answered on 20 Feb Learn Informatica +1 SAP

Sana Begum

My teaching experience 12 years

A PowerCenter mapping specifies how to move data between sources and targets. A Developer tool mapping specifies how to move data between the mapping input and output. A PowerCenter mapping must include one or more source definitions, source qualifiers, and target definitions.
Answers 2 Comments
Dislike Bookmark

Answered on 20 Feb Learn Informatica +1 SAP

Sana Begum

My teaching experience 12 years

It is more cost-effective than Informatica in terms of value, preparation, and asset allocation. Further, it is up-to-date on Big Data technologies like Spark, Hive, AWS, etc. Talend is preferable for BIG data. Informatica's new version supports BIG data however with a defined purpose, they only approve... read more
It is more cost-effective than Informatica in terms of value, preparation, and asset allocation. Further, it is up-to-date on Big Data technologies like Spark, Hive, AWS, etc. Talend is preferable for BIG data. Informatica's new version supports BIG data however with a defined purpose, they only approve Hive read less
Answers 2 Comments
Dislike Bookmark

Learn Informatica from the Best Tutors

  • Affordable fees
  • Flexible Timings
  • Choose between 1-1 and Group class
  • Verified Tutors

Answered on 20 Feb Learn Informatica +1 SAP

Sana Begum

My teaching experience 12 years

The Integration Service connects to the repository through the Repository Service to fetch metadata from the repository. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data. The Integration Service runs workflow tasks
Answers 2 Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best Informatica Training in India. Post Your Requirement today and get connected.

Overview

Questions 481

Total Shares  

+ Follow 8,261 Followers

You can also Learn

Top Contributors

Connect with Expert Tutors & Institutes for Informatica

x

Ask a Question

Please enter your Question

Please select a Tag

X

Looking for Informatica Classes?

The best tutors for Informatica Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Informatica with the Best Tutors

The best Tutors for Informatica Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more